posts_gdocs_links
Data license: CC-BY
70 rows where sourceId = "1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc"
This data as json, CSV (advanced)
Suggested facets: linkType, componentType, queryString, hash
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
1877716 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://ourworldindata.org/human-rights | url | topic-page-intro | Human Rights | ||
1877717 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://ourworldindata.org/women-rights | url | topic-page-intro | Women’s Rights | ||
1877718 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://ourworldindata.org/lgbt-rights | url | topic-page-intro | LGBT+ Rights | ||
1877719 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://ourworldindata.org/war-and-peace | url | topic-page-intro | War and Peace | ||
1877720 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://www.annualreviews.org/doi/abs/10.1146/annurev-polisci-060820-060910 | url | span-link | better governed | ||
1877721 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://www.journals.uchicago.edu/doi/abs/10.1086/700936?mobileUi=0& | url | span-link | grow faster | ?mobileUi=0& | |
1877722 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://global.oup.com/academic/product/the-death-and-life-of-state-repression-9780197655375?cc=us&lang=en&# | url | span-link | within | ?cc=us&lang=en& | # |
1877723 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://www.cambridge.org/core/journals/international-organization/article/abs/suffragist-peace/3FC70A0BE87859F624E42984BEB0322B | url | span-link | between | ||
1877724 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | countries-democracies-autocracies-row | grapher | key-insights | The world has become much more democratic over the last two centuries | ||
1877725 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | people-living-in-democracies-autocracies | grapher | key-insights | Two centuries ago, everyone lacked democratic rights. Now, billions of people have them | ||
1877726 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | number-electoral-democracies-age | grapher | key-insights | Many democracies are less than a generation old. Dictatorship is far from a distant memory | ||
1877727 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | distribution-electoral-democracy-vdem | grapher | key-insights | People around the world have gained democratic rights, but some have many more rights than others | ||
1877728 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | countries-democratizing-autocratizing-countries-ert | grapher | key-insights | The world has recently become less democratic | ?stackMode=absolute | |
1877729 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://www.v-dem.net/vdemds.html | url | span-link | Varieties of Democracy project | ||
1877730 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://ourworldindata.org/regimes-of-the-world-data | url | span-link | our technical article on the RoW data | ||
1877731 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | democracy | explorer | span-link | Democracy Data Explorer | ?country=ARG~AUS~BWA~CHN~OWID_WRL&Dataset=Varieties+of+Democracy&Metric=Electoral+democracy&Sub-metric=Main+index | |
1877732 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | democracy | explorer | span-link | classified as electoral autocracies | ?time=2017&Dataset=Regimes+of+the+World&Metric=%C2%ADPolitical+regime&Sub-metric=Main+classification&country=ARG~AUS~BWA~CHN | |
1877733 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://ourworldindata.org/less-democratic#the-democratic-decline-has-been-substantial-but-more-uncertain-and-limited | url | span-link | data sources | #the-democratic-decline-has-been-substantial-but-more-uncertain-and-limited | |
1877734 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 1ghyH3pzHeRNxnDNZ78FXfIqea6ULupeS3KyCMRoH80A | gdoc | prominent-link | |||
1877735 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://www.v-dem.net/vdemds.html | url | span-link | Varieties of Democracy project | ||
1877736 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://ourworldindata.org/regimes-of-the-world-data | url | span-link | our technical article on the RoW data | ||
1877737 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | democracy | explorer | span-link | Democracy Data Explorer | ?country=ARG~AUS~BWA~CHN~OWID_WRL&Dataset=Varieties+of+Democracy&Metric=Electoral+democracy&Sub-metric=Main+index | |
1877738 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | number-liberal-democracies-age | grapher | span-link | Liberal democracy | ||
1877739 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | number-democracies-age-bmr | grapher | span-link | measure | ||
1877740 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 10mpw95MM1OZO__0g75j1rHhEp2pjBlDnUcY08uyvn_E | gdoc | prominent-link | |||
1877741 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://www.v-dem.net/vdemds.html | url | span-link | Varieties of Democracy project | ||
1877742 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://ourworldindata.org/regimes-of-the-world-data | url | span-link | our technical article on the RoW data | ||
1877743 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | democracy | explorer | span-link | Democracy Data Explorer | ?country=ARG~AUS~BWA~CHN~OWID_WRL&Dataset=Varieties+of+Democracy&Metric=Electoral+democracy&Sub-metric=Main+index | |
1877744 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | distribution-electoral-democracy-vdem | grapher | span-link | 100 years ago | ?time=1922 | |
1877745 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | distribution-liberal-democracy-vdem | grapher | span-link | liberal democracy | ||
1877746 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | distribution-democracy-polity | grapher | span-link | other leading approaches | ||
1877747 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 1LNnYyow4VGpM-z8R80D3GbzGHfodTv0EEvBceJxvgR8 | gdoc | prominent-link | |||
1877748 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://www.v-dem.net/vdemds.html | url | span-link | Varieties of Democracy project | ||
1877749 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://ourworldindata.org/vdem-electoral-democracy-data | url | span-link | our article on the data | ||
1877750 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | democracy | explorer | span-link | Democracy Data Explorer | ?country=ARG~AUS~BWA~CHN~OWID_WRL&Dataset=Varieties+of+Democracy&Metric=Electoral+democracy&Sub-metric=Main+index | |
1877751 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | countries-that-are-democratizing-and-autocratizing-within-regimes | grapher | span-link | eroding democracies and hardening autocracies | ||
1877752 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | countries-democracies-autocracies-row | grapher | span-link | number of democracies | ?stackMode=absolute&country=~OWID_WRL | |
1877753 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | people-living-in-democracies-autocracies | grapher | span-link | people are living in democracies | ||
1877754 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | electoral-democracy | grapher | span-link | countries | ||
1877755 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | electoral-democracy-popw-vdem | grapher | span-link | people | ||
1877756 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | people-living-in-democratizing-autocratizing-countries-ert | grapher | span-link | more people live in | ||
1877757 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 14ThFloGyQv4uSGdEeZROWq_2yvHC9ggnAFij_9Oyz6g | gdoc | prominent-link | |||
1877758 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://www.v-dem.net/ertds.html | url | span-link | Episodes of Regime Transformation project | ||
1877759 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | democracy | explorer | span-link | Democracy Data Explorer | ?country=ARG~AUS~BWA~CHN~OWID_WRL&Dataset=Varieties+of+Democracy&Metric=Electoral+democracy&Sub-metric=Main+index | |
1877760 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | democracy | explorer | chart | |||
1877761 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 1vMsru_zjboUD_W5aBXoMKMMxCxqyJ4oYVCfchYBzDQM | gdoc | prominent-link | |||
1877762 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 1ghyH3pzHeRNxnDNZ78FXfIqea6ULupeS3KyCMRoH80A | gdoc | research-and-writing | |||
1877763 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 14ThFloGyQv4uSGdEeZROWq_2yvHC9ggnAFij_9Oyz6g | gdoc | research-and-writing | |||
1877764 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 1vMsru_zjboUD_W5aBXoMKMMxCxqyJ4oYVCfchYBzDQM | gdoc | research-and-writing | |||
1877765 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 14zTYMg-mkPcMC68DqgQNb1eAe8VBwoD93yzyKGIeguw | gdoc | research-and-writing | |||
1877766 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 1xO9wHbwM5LKlGFbHyet3CLmiqnI3ZOHS8V3P_81Itf4 | gdoc | research-and-writing | |||
1877767 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 10mpw95MM1OZO__0g75j1rHhEp2pjBlDnUcY08uyvn_E | gdoc | research-and-writing | |||
1877768 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 1LNnYyow4VGpM-z8R80D3GbzGHfodTv0EEvBceJxvgR8 | gdoc | research-and-writing | |||
1877769 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | 15TD9DyPmgOUFC8pMzMczLJmNTIw_j-gBM32JpInPJIU | gdoc | research-and-writing | |||
1877770 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | political-regime | grapher | all-charts | |||
1877771 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | electoral-democracy-index | grapher | all-charts | |||
1877772 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | countries-democracies-autocracies-row | grapher | all-charts | |||
1877773 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | people-living-in-democracies-autocracies | grapher | all-charts | |||
1877774 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | number-electoral-democracies-age | grapher | all-charts | |||
1877775 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | distribution-electoral-democracy-vdem | grapher | all-charts | |||
1877776 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | countries-that-are-democratizing-and-autocratizing | grapher | all-charts | |||
1877777 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://scholar.google.com/scholar?hl=en&as_sdt=0%2C5&q=L%C3%BChrmann%2C+Anna%2C+Marcus+Tannenberg%2C+and+Staffan+Lindberg.+2018.+Regimes+of+the+World+%28RoW%29%3A+Opening+New+Avenues+for+the+Comparative+Study+of+Political+Regimes.+Politics+and+Governance+6%281%29%3A+60-77.&btnG= | url | span-link | Regimes of the World (RoW): Opening New Avenues for the Comparative Study of Political Regimes | ?hl=en&as_sdt=0%2C5&q=L%C3%BChrmann%2C+Anna%2C+Marcus+Tannenberg%2C+and+Staffan+Lindberg.+2018.+Regimes+of+the+World+%28RoW%29%3A+Opening+New+Avenues+for+the+Comparative+Study+of+Political+Regimes.+Politics+and+Governance+6%281%29%3A+60-77.&btnG= | |
1877778 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://scholar.google.com/scholar?hl=en&as_sdt=0%2C5&q=Coppedge%2C+Michael%2C+John+Gerring%2C+Carl+Henrik+Knutsen%2C+Staffan+I.+Lindberg%2C+Jan+Teorell%2C+David+Altman%2C+Fabio+Angiolillo%2C+Michael+Bernhard%2C+Cecilia+Borella%2C+Agnes+Cornell%2C+M.+Steven+Fish%2C+Linnea+Fox%2C+Lisa+Gastaldi%2C+Haakon+Gjerl%C3%B8w%2C+Adam+Glynn%2C+Ana+Good+God%2C+Sandra+Grahn%2C+Allen+Hicken%2C+Katrin+Kinzelbach%2C+Joshua+Krusell%2C+Kyle+L.+Marquardt%2C+Kelly+McMann%2C+Valeriya+Mechkova%2C+Juraj+Medzihorsky%2C+Natalia+Natsika%2C+Anja+Neundorf%2C+Pamela+Paxton%2C+Daniel+Pemstein%2C+Josefine+Pernes%2C+Oskar+Ryd%C3%A9n%2C+Johannes+von+R%C3%B6mer%2C+Brigitte+Seim%2C+Rachel+Sigman%2C+Svend-Erik+Skaaning%2C+Jeffrey+Staton%2C+Aksel+Sundstr%C3%B6m%2C+Eitan+Tzelgov%2C+Yi-ting+Wang%2C+Tore+Wig%2C+Steven+Wilson+and+Daniel+Ziblatt.+2024.+%22V-Dem+Country-Year+Dataset+v14%22+Varieties+of+Democracy+%28V-Dem%29+Project.+https%3A%2F%2Fdoi.org%2F10.23696%2Fmcwt-fr58&btnG= | url | span-link | V-Dem Country-Year Dataset v14 | ?hl=en&as_sdt=0%2C5&q=Coppedge%2C+Michael%2C+John+Gerring%2C+Carl+Henrik+Knutsen%2C+Staffan+I.+Lindberg%2C+Jan+Teorell%2C+David+Altman%2C+Fabio+Angiolillo%2C+Michael+Bernhard%2C+Cecilia+Borella%2C+Agnes+Cornell%2C+M.+Steven+Fish%2C+Linnea+Fox%2C+Lisa+Gastaldi%2C+Haakon+Gjerl%C3%B8w%2C+Adam+Glynn%2C+Ana+Good+God%2C+Sandra+Grahn%2C+Allen+Hicken%2C+Katrin+Kinzelbach%2C+Joshua+Krusell%2C+Kyle+L.+Marquardt%2C+Kelly+McMann%2C+Valeriya+Mechkova%2C+Juraj+Medzihorsky%2C+Natalia+Natsika%2C+Anja+Neundorf%2C+Pamela+Paxton%2C+Daniel+Pemstein%2C+Josefine+Pernes%2C+Oskar+Ryd%C3%A9n%2C+Johannes+von+R%C3%B6mer%2C+Brigitte+Seim%2C+Rachel+Sigman%2C+Svend-Erik+Skaaning%2C+Jeffrey+Staton%2C+Aksel+Sundstr%C3%B6m%2C+Eitan+Tzelgov%2C+Yi-ting+Wang%2C+Tore+Wig%2C+Steven+Wilson+and+Daniel+Ziblatt.+2024.+%22V-Dem+Country-Year+Dataset+v14%22+Varieties+of+Democracy+%28V-Dem%29+Project.+https%3A%2F%2Fdoi.org%2F10.23696%2Fmcwt-fr58&btnG= | |
1877779 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://web.archive.org/web/20220130230849/https://v-dem.net/static/website/files/dr/dr_2021.pdf | url | span-link | |||
1877780 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://web.archive.org/web/20220130230849/https://v-dem.net/static/website/files/dr/dr_2021.pdf | url | span-link | Autocratization Turns Viral | ||
1877781 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://scholar.google.com/scholar?hl=en&as_sdt=0%2C5&q=Edgell%2C+Amanda+B.%2C+Seraphine+F.+Maerz%2C+Laura+Maxwell%2C+Richard+Morgan%2C+Juraj+Medzi-+horsky%2C+Matthew+C.+Wilson%2C+Vanessa+A.+Boese%2C+Sebastian+Hellmeier%2C+Jean+Lachapelle%2C+Patrik+Lindenfors%2C+Anna+L%C3%BChrmann%2C+and+Staffan+I.+Lindberg.+%282024%29.+Episodes+of+Regime+Transformation+Dataset+%28v14.0%29.+Varieties+of+Democracy+%28V-Dem%29+Project.+Available+at%3A+www.github.com%2Fvdeminstitute%2Fert&btnG= | url | span-link | Episodes of Regime Transformation Dataset (v14.0) | ?hl=en&as_sdt=0%2C5&q=Edgell%2C+Amanda+B.%2C+Seraphine+F.+Maerz%2C+Laura+Maxwell%2C+Richard+Morgan%2C+Juraj+Medzi-+horsky%2C+Matthew+C.+Wilson%2C+Vanessa+A.+Boese%2C+Sebastian+Hellmeier%2C+Jean+Lachapelle%2C+Patrik+Lindenfors%2C+Anna+L%C3%BChrmann%2C+and+Staffan+I.+Lindberg.+%282024%29.+Episodes+of+Regime+Transformation+Dataset+%28v14.0%29.+Varieties+of+Democracy+%28V-Dem%29+Project.+Available+at%3A+www.github.com%2Fvdeminstitute%2Fert&btnG= | |
1877782 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | political-regime-ert | grapher | span-link | This | ||
1877783 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://scholar.google.com/scholar?hl=en&as_sdt=0%2C5&q=Seraphine+Maerz%2C+Amanda+Edgell%2C+Matthew+Wilson%2C+Sebastian+Hellmeier%2C+Staffan++Lindberg.+2021.+A+Framework+for+Understanding+Regime+Transformation%3A+Introducing+the+ERT+Dataset.+Varieties+of+Democracy+Institute%3A+Working+Paper+No.+113.++University+of+Gothenburg.&btnG= | url | span-link | A Framework for Understanding Regime Transformation: Introducing the ERT Dataset | ?hl=en&as_sdt=0%2C5&q=Seraphine+Maerz%2C+Amanda+Edgell%2C+Matthew+Wilson%2C+Sebastian+Hellmeier%2C+Staffan++Lindberg.+2021.+A+Framework+for+Understanding+Regime+Transformation%3A+Introducing+the+ERT+Dataset.+Varieties+of+Democracy+Institute%3A+Working+Paper+No.+113.++University+of+Gothenburg.&btnG= | |
1877784 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | democracy | explorer | span-link | United States in the 2010s | ?tab=chart&time=2003..latest&facet=none&country=~USA&Dataset=Varieties+of+Democracy&Metric=Electoral+democracy&Sub-metric=Main+index | |
1877785 | Democracy 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc | https://scholar.google.com/scholar?hl=en&as_sdt=0%2C5&q=Bermeo%2C+Nancy.+2016.+On+democratic+backsliding.+Journal+of+Democracy+27%281%29%3A+5-19.&btnG= | url | span-link | On democratic backsliding | ?hl=en&as_sdt=0%2C5&q=Bermeo%2C+Nancy.+2016.+On+democratic+backsliding.+Journal+of+Democracy+27%281%29%3A+5-19.&btnG= |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "posts_gdocs_links" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "sourceId" VARCHAR(255) NULL , "target" TEXT NOT NULL , "linkType" TEXT NULL , "componentType" VARCHAR(255) NOT NULL , "text" VARCHAR(255) NOT NULL , "queryString" VARCHAR(2047) NOT NULL , "hash" VARCHAR(2047) NOT NULL, FOREIGN KEY("sourceId") REFERENCES "posts_gdocs" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION ); CREATE INDEX "sourceId" ON "posts_gdocs_links" ("sourceId");