Large place-based subreddits, as per the Global List of Local Reddits. Data downloaded from Pushshift. All subreddits had >= 1000 posts in Pushshift on April 3rd, 2021.
Tables
| Name | Type |
|---|---|
| 01535 | StaticDataTable |
| 01960 | StaticDataTable |
| 06443 | StaticDataTable |
| 12901 | StaticDataTable |
| 219 | StaticDataTable |
| 251 | StaticDataTable |
| 3066 | StaticDataTable |
| 321 | StaticDataTable |
| 386 | StaticDataTable |
| 407 | StaticDataTable |
| 413 | StaticDataTable |
| 44646 | StaticDataTable |
| 609 | StaticDataTable |
| 618 | StaticDataTable |
| 757 | StaticDataTable |
| 772 | StaticDataTable |
| 863 | StaticDataTable |
| 905 | StaticDataTable |
| 909 | StaticDataTable |
| 94901 | StaticDataTable |
| Adelaide | StaticDataTable |
| Amsterdam | StaticDataTable |
| Anaheim | StaticDataTable |
| Anchorage | StaticDataTable |
| Antarctica | StaticDataTable |
| Aruba | StaticDataTable |
| Austin | StaticDataTable |
| Bakersfield | StaticDataTable |
| BalticStates | StaticDataTable |
| BayArea | StaticDataTable |
| Belfast | StaticDataTable |
| BeloHorizonte | StaticDataTable |
| BigBear | StaticDataTable |
| BigBendTX | StaticDataTable |
| Bishop | StaticDataTable |
| Breckenridge | StaticDataTable |
| Britain | StaticDataTable |
| Buenzli | StaticDataTable |
| CAR_ | StaticDataTable |
| Caribbean | StaticDataTable |
| Cascadia | StaticDataTable |
| Catalunya | StaticDataTable |
| Chengdu | StaticDataTable |
| ChicoCA | StaticDataTable |
| CoachellaValley | StaticDataTable |
| Corona | StaticDataTable |
| DaytonaBeach | StaticDataTable |
| Dominican | StaticDataTable |
| Dorchester | StaticDataTable |
| Edinburgh | StaticDataTable |
| Edmonton | StaticDataTable |
| Eindhoven | StaticDataTable |
| England | StaticDataTable |
| Essex | StaticDataTable |
| EstadosUnidos | StaticDataTable |
| ForestofBowland | StaticDataTable |
| FortMyers | StaticDataTable |
| FortSaskatchewan | StaticDataTable |
| Fresno | StaticDataTable |
| Gaza | StaticDataTable |
| Glasgow | StaticDataTable |
| Greeley | StaticDataTable |
| Guadalajara | StaticDataTable |
| HighDesert | StaticDataTable |
| HuntingtonBeach | StaticDataTable |
| InlandEmpire | StaticDataTable |
| Irvine | StaticDataTable |
| Italia | StaticDataTable |
| KeyWest | StaticDataTable |
| KingdomofSaudiArabia | StaticDataTable |
| KingstonOntario | StaticDataTable |
| Kyoto | StaticDataTable |
| Lacombe | StaticDataTable |
| Livermore | StaticDataTable |
| Liverpool | StaticDataTable |
| Logan | StaticDataTable |
| London | StaticDataTable |
| LongBeach | StaticDataTable |
| LosAngeles | StaticDataTable |
| Manaus | StaticDataTable |
| Manchester | StaticDataTable |
| MedfordMass | StaticDataTable |
| MexicoCity | StaticDataTable |
| MiddleEast | StaticDataTable |
| Milwaukee | StaticDataTable |
| Modesto | StaticDataTable |
| MontereyBay | StaticDataTable |
| NOLA | StaticDataTable |
| NearWestSuburbs | StaticDataTable |
| NewBrunswickNJ | StaticDataTable |
| Olympia | StaticDataTable |
| OrangeCounty | StaticDataTable |
| Oshawa | StaticDataTable |
| PacificNorthwest | StaticDataTable |
| Paisley | StaticDataTable |
| Pasadena | StaticDataTable |
| Pattaya | StaticDataTable |
| Polska | StaticDataTable |
| PortlandMaine | StaticDataTable |
| Portsmouth | StaticDataTable |
| Redding | StaticDataTable |
| Republica_Argentina | StaticDataTable |
| RichmondBC | StaticDataTable |
| Roseville | StaticDataTable |
| SFV | StaticDataTable |
| Sacramento | StaticDataTable |
| SalemMA | StaticDataTable |
| SanDiego | StaticDataTable |
| SanFrancisco | StaticDataTable |
| SanJose | StaticDataTable |
| SantaBarbara | StaticDataTable |
| SantaCruz | StaticDataTable |
| Santamonica | StaticDataTable |
| SaultSteMarie | StaticDataTable |
| Scranton | StaticDataTable |
| Seattle | StaticDataTable |
| SeattleWA | StaticDataTable |
| Sheffield | StaticDataTable |
| SilverSpring | StaticDataTable |
| Slovenija | StaticDataTable |
| Somalia | StaticDataTable |
| SouthAsia | StaticDataTable |
| SouthBayLA | StaticDataTable |
| SouthBend | StaticDataTable |
| StamfordCT | StaticDataTable |
| Steubenville | StaticDataTable |
| Syria | StaticDataTable |
| Taranto | StaticDataTable |
| TheHague | StaticDataTable |
| Triangle | StaticDataTable |
| TrinidadandTobago | StaticDataTable |
| Uganda | StaticDataTable |
| Ventura | StaticDataTable |
| Visalia | StaticDataTable |
| Wales | StaticDataTable |
| Waltham | StaticDataTable |
| Wisconsin | StaticDataTable |
| Wyoming | StaticDataTable |
| Yemen | StaticDataTable |
| York | StaticDataTable |
| Youngstown | StaticDataTable |
| ZionNP | StaticDataTable |
| aachen | StaticDataTable |
| aalborg | StaticDataTable |
| aarhus | StaticDataTable |
| abbotsford | StaticDataTable |
| aberdeen | StaticDataTable |
| abudhabi | StaticDataTable |
| acadiana | StaticDataTable |
| adirondacks | StaticDataTable |
| afghanistan | StaticDataTable |
| africa | StaticDataTable |
| ahmedabad | StaticDataTable |
| aixmarseille | StaticDataTable |
| akron | StaticDataTable |
| alabama | StaticDataTable |
| alameda | StaticDataTable |
| alaska | StaticDataTable |
| albania | StaticDataTable |
| albany | StaticDataTable |
| alberta | StaticDataTable |
| albuquerque | StaticDataTable |
| algeria | StaticDataTable |
| algonquinpark | StaticDataTable |
| alpharetta | StaticDataTable |
| amarillo | StaticDataTable |
| america | StaticDataTable |
| ames | StaticDataTable |
| andorra | StaticDataTable |
| angola | StaticDataTable |
| ankara | StaticDataTable |
| annapolis | StaticDataTable |
| annarbor | StaticDataTable |
| antwerpen | StaticDataTable |
| argentina | StaticDataTable |
| arizona | StaticDataTable |
| arkansas | StaticDataTable |
| arlington | StaticDataTable |
| armenia | StaticDataTable |
| armenian | StaticDataTable |
| aschaffenburg | StaticDataTable |
| asheville | StaticDataTable |
| asia | StaticDataTable |
| assam | StaticDataTable |
| assyria | StaticDataTable |
| astoria | StaticDataTable |
| athens | StaticDataTable |
| athensohio | StaticDataTable |
| atlanta | StaticDataTable |
| atlanticcity | StaticDataTable |
| auburn | StaticDataTable |
| auckland | StaticDataTable |
| augusta | StaticDataTable |
| auroraco | StaticDataTable |
| australia | StaticDataTable |
| austria | StaticDataTable |
| azerbaijan | StaticDataTable |
| azores | StaticDataTable |
| bahamas | StaticDataTable |
| bahrain | StaticDataTable |
| bali | StaticDataTable |
| balkans | StaticDataTable |
| ballarat | StaticDataTable |
| baltimore | StaticDataTable |
| bangalore | StaticDataTable |
| bangkok | StaticDataTable |
| bangladesh | StaticDataTable |
| barbados | StaticDataTable |
| barcelona | StaticDataTable |
| bari | StaticDataTable |
| barrie | StaticDataTable |
| bastroptx | StaticDataTable |
| bath | StaticDataTable |
| batonrouge | StaticDataTable |
| beaverton | StaticDataTable |
| beijing | StaticDataTable |
| belarus | StaticDataTable |
| belgium | StaticDataTable |
| belize | StaticDataTable |
| bellevue | StaticDataTable |
| bellevuewa | StaticDataTable |
| bellingham | StaticDataTable |
| bemidji | StaticDataTable |
| bend | StaticDataTable |
| bergen | StaticDataTable |
| berlin | StaticDataTable |
| bermuda | StaticDataTable |
| bethesda | StaticDataTable |
| bhutan | StaticDataTable |
| bigisland | StaticDataTable |
| bih | StaticDataTable |
| bihar | StaticDataTable |
| billings | StaticDataTable |
| biloxi | StaticDataTable |
| binghamton | StaticDataTable |
| birmingham | StaticDataTable |
| bloomington | StaticDataTable |
| bloomingtonnormal | StaticDataTable |
| boise | StaticDataTable |
| bolivia | StaticDataTable |
| bonn | StaticDataTable |
| bosnia | StaticDataTable |
| boston | StaticDataTable |
| botswana | StaticDataTable |
| boulder | StaticDataTable |
| bournemouth | StaticDataTable |
| bozeman | StaticDataTable |
| bradenton | StaticDataTable |
| brampton | StaticDataTable |
| brantford | StaticDataTable |
| brasil | StaticDataTable |
| brazil | StaticDataTable |
| bremen | StaticDataTable |
| bretagne | StaticDataTable |
| brighton | StaticDataTable |
| brisbane | StaticDataTable |
| bristol | StaticDataTable |
| britishcolumbia | StaticDataTable |
| brno | StaticDataTable |
| bronx | StaticDataTable |
| brooklyn | StaticDataTable |
| broward | StaticDataTable |
| brum | StaticDataTable |
| brunei | StaticDataTable |
| brussels | StaticDataTable |
| buckscountypa | StaticDataTable |
| bucovina | StaticDataTable |
| bucuresti | StaticDataTable |
| budapest | StaticDataTable |
| buenosaires | StaticDataTable |
| buffalo | StaticDataTable |
| bulgaria | StaticDataTable |
| bullcity | StaticDataTable |
| burbank | StaticDataTable |
| burlington | StaticDataTable |
| burlingtonon | StaticDataTable |
| burnaby | StaticDataTable |
| bushwick | StaticDataTable |
| cairns | StaticDataTable |
| calgary | StaticDataTable |
| california | StaticDataTable |
| cambodia | StaticDataTable |
| cambridge | StaticDataTable |
| cambridgeMA | StaticDataTable |
| canada | StaticDataTable |
| canberra | StaticDataTable |
| cancun | StaticDataTable |
| canterbury | StaticDataTable |
| canton | StaticDataTable |
| capebreton | StaticDataTable |
| capecod | StaticDataTable |
| capetown | StaticDataTable |
| cardiff | StaticDataTable |
| catalonia | StaticDataTable |
| cebu | StaticDataTable |
| cedarrapids | StaticDataTable |
| centralillinois | StaticDataTable |
| centralpa | StaticDataTable |
| centralvalley | StaticDataTable |
| cesky | StaticDataTable |
| chandigarh | StaticDataTable |
| chapelhill | StaticDataTable |
| charleston | StaticDataTable |
| charlotte | StaticDataTable |
| charlottesville | StaticDataTable |
| chattanooga | StaticDataTable |
| chch | StaticDataTable |
| chennai | StaticDataTable |
| chicago | StaticDataTable |
| chicagosuburbs | StaticDataTable |
| chile | StaticDataTable |
| china | StaticDataTable |
| cincinnati | StaticDataTable |
| clarksville | StaticDataTable |
| clearlake | StaticDataTable |
| clearwaterfl | StaticDataTable |
| cleveland | StaticDataTable |
| cluj | StaticDataTable |
| coeurdalene | StaticDataTable |
| cologne | StaticDataTable |
| colombia | StaticDataTable |
| colorado | StaticDataTable |
| coloradosprings | StaticDataTable |
| columbiamd | StaticDataTable |
| columbiamo | StaticDataTable |
| columbus | StaticDataTable |
| columbusga | StaticDataTable |
| comoxvalley | StaticDataTable |
| congo | StaticDataTable |
| connecticut | StaticDataTable |
| copenhagen | StaticDataTable |
| cordoba | StaticDataTable |
| cork | StaticDataTable |
| cornwall | StaticDataTable |
| corpus | StaticDataTable |
| corvallis | StaticDataTable |
| costa_rica | StaticDataTable |
| coventry | StaticDataTable |
| croatia | StaticDataTable |
| cuba | StaticDataTable |
| curitiba | StaticDataTable |
| cymru | StaticDataTable |
| cyprus | StaticDataTable |
| czech | StaticDataTable |
| dachschaden | StaticDataTable |
| daejeon | StaticDataTable |
| dallas | StaticDataTable |
| dartmoor | StaticDataTable |
| darwin | StaticDataTable |
| davao | StaticDataTable |
| dayton | StaticDataTable |
| de | StaticDataTable |
| delaware | StaticDataTable |
| delhi | StaticDataTable |
| denmark | StaticDataTable |
| denton | StaticDataTable |
| denver | StaticDataTable |
| desmoines | StaticDataTable |
| destin | StaticDataTable |
| detroit | StaticDataTable |
| deutschland | StaticDataTable |
| devonuk | StaticDataTable |
| dhaka | StaticDataTable |
| downriver | StaticDataTable |
| dresden | StaticDataTable |
| dubai | StaticDataTable |
| dublin | StaticDataTable |
| dubrovnik | StaticDataTable |
| duesseldorf | StaticDataTable |
| duluth | StaticDataTable |
| dundee | StaticDataTable |
| dunedin | StaticDataTable |
| durango | StaticDataTable |
| durban | StaticDataTable |
| durham | StaticDataTable |
| eastbay | StaticDataTable |
| eastside | StaticDataTable |
| ecuador | StaticDataTable |
| eesti | StaticDataTable |
| egypt | StaticDataTable |
| elkgrove | StaticDataTable |
| elpaso | StaticDataTable |
| elsalvador | StaticDataTable |
| erie | StaticDataTable |
| eritrea | StaticDataTable |
| es | StaticDataTable |
| escondido | StaticDataTable |
| espana | StaticDataTable |
| ethiopia | StaticDataTable |
| eugene | StaticDataTable |
| europe | StaticDataTable |
| europeanfederalists | StaticDataTable |
| evansville | StaticDataTable |
| everett | StaticDataTable |
| exeter | StaticDataTable |
| fairbanks | StaticDataTable |
| fargo | StaticDataTable |
| faroeislands | StaticDataTable |
| fayettenam | StaticDataTable |
| fayetteville | StaticDataTable |
| fijian | StaticDataTable |
| finland | StaticDataTable |
| firstnations | StaticDataTable |
| flagstaff | StaticDataTable |
| flint | StaticDataTable |
| florida | StaticDataTable |
| floridakeys | StaticDataTable |
| fortcollins | StaticDataTable |
| fortlauderdale | StaticDataTable |
| fortwayne | StaticDataTable |
| fortworth | StaticDataTable |
| france | StaticDataTable |
| frankfurt | StaticDataTable |
| frederickmd | StaticDataTable |
| fredericksburg | StaticDataTable |
| fredericton | StaticDataTable |
| freiburg | StaticDataTable |
| freising | StaticDataTable |
| fremont | StaticDataTable |
| frisco | StaticDataTable |
| fukuoka | StaticDataTable |
| galiza | StaticDataTable |
| galveston | StaticDataTable |
| galway | StaticDataTable |
| gasteiz | StaticDataTable |
| gatineau | StaticDataTable |
| geelong | StaticDataTable |
| geneva | StaticDataTable |
| gent | StaticDataTable |
| georgia | StaticDataTable |
| germany | StaticDataTable |
| ghana | StaticDataTable |
| gifhorn | StaticDataTable |
| glacier | StaticDataTable |
| glendale | StaticDataTable |
| gnv | StaticDataTable |
| goa | StaticDataTable |
| goldcoast | StaticDataTable |
| gothenburg | StaticDataTable |
| grandcanyon | StaticDataTable |
| grandeprairie | StaticDataTable |
| grandjunction | StaticDataTable |
| grandrapids | StaticDataTable |
| graz | StaticDataTable |
| greece | StaticDataTable |
| greekreddit | StaticDataTable |
| greenbay | StaticDataTable |
| greenland | StaticDataTable |
| greenville | StaticDataTable |
| greifswald | StaticDataTable |
| groningen | StaticDataTable |
| grossepointe | StaticDataTable |
| gso | StaticDataTable |
| guam | StaticDataTable |
| guangzhou | StaticDataTable |
| guatemala | StaticDataTable |
| guelph | StaticDataTable |
| guernsey | StaticDataTable |
| guyana | StaticDataTable |
| gwangju | StaticDataTable |
| gwinnett | StaticDataTable |
| hagerstown | StaticDataTable |
| haiti | StaticDataTable |
| halifax | StaticDataTable |
| hamburg | StaticDataTable |
| hamilton | StaticDataTable |
| hamptonroads | StaticDataTable |
| hannover | StaticDataTable |
| harrisburg | StaticDataTable |
| harrisonburg | StaticDataTable |
| hartford | StaticDataTable |
| hattiesburg | StaticDataTable |
| hawaii | StaticDataTable |
| heidelberg | StaticDataTable |
| helsinki | StaticDataTable |
| hillsboro | StaticDataTable |
| hobart | StaticDataTable |
| hoboken | StaticDataTable |
| honduras | StaticDataTable |
| hongkong | StaticDataTable |
| honolulu | StaticDataTable |
| houston | StaticDataTable |
| hu | StaticDataTable |
| hudsonvalley | StaticDataTable |
| hull | StaticDataTable |
| humboldt | StaticDataTable |
| hungary | StaticDataTable |
| huntsvillealabama | StaticDataTable |
| hyderabad | StaticDataTable |
| ibiza | StaticDataTable |
| iceland | StaticDataTable |
| idaho | StaticDataTable |
| illinois | StaticDataTable |
| india | StaticDataTable |
| indiana | StaticDataTable |
| indianapolis | StaticDataTable |
| indonesia | StaticDataTable |
| iowa | StaticDataTable |
| iowacity | StaticDataTable |
| ipswichuk | StaticDataTable |
| iran | StaticDataTable |
| iranian | StaticDataTable |
| iraq | StaticDataTable |
| ireland | StaticDataTable |
| islamabad | StaticDataTable |
| isleofman | StaticDataTable |
| israel | StaticDataTable |
| istanbul | StaticDataTable |
| it | StaticDataTable |
| italy | StaticDataTable |
| ithaca | StaticDataTable |
| izmir | StaticDataTable |
| ja | StaticDataTable |
| jacksonms | StaticDataTable |
| jacksonville | StaticDataTable |
| jaipur | StaticDataTable |
| jakarta | StaticDataTable |
| jamaica | StaticDataTable |
| japan | StaticDataTable |
| jerseycity | StaticDataTable |
| johannesburg | StaticDataTable |
| joplinmo | StaticDataTable |
| jordan | StaticDataTable |
| joshuatree | StaticDataTable |
| juneau | StaticDataTable |
| kaernten | StaticDataTable |
| kamloops | StaticDataTable |
| kansas | StaticDataTable |
| kansascity | StaticDataTable |
| kaposvar | StaticDataTable |
| karachi | StaticDataTable |
| karnataka | StaticDataTable |
| kashmir | StaticDataTable |
| kauai | StaticDataTable |
| kazakhstan | StaticDataTable |
| kelowna | StaticDataTable |
| kennesaw | StaticDataTable |
| kenosha | StaticDataTable |
| kentucky | StaticDataTable |
| kenya | StaticDataTable |
| kerala | StaticDataTable |
| kitchener | StaticDataTable |
| kitsap | StaticDataTable |
| knoxville | StaticDataTable |
| kolkata | StaticDataTable |
| korea | StaticDataTable |
| kosovo | StaticDataTable |
| krakow | StaticDataTable |
| kualalumpur | StaticDataTable |
| kurdistan | StaticDataTable |
| kuwait | StaticDataTable |
| kyrgyzstan | StaticDataTable |
| kzoo | StaticDataTable |
| lacrossewi | StaticDataTable |
| lafayette | StaticDataTable |
| lagos | StaticDataTable |
| lahore | StaticDataTable |
| lakecharles | StaticDataTable |
| lakeland | StaticDataTable |
| lalaguna | StaticDataTable |
| lancaster | StaticDataTable |
| lansing | StaticDataTable |
| laos | StaticDataTable |
| laramie | StaticDataTable |
| laredo | StaticDataTable |
| lascruces | StaticDataTable |
| lasvegas | StaticDataTable |
| latinamerica | StaticDataTable |
| latinoamerica | StaticDataTable |
| latvia | StaticDataTable |
| lawrence | StaticDataTable |
| lebanon | StaticDataTable |
| leeds | StaticDataTable |
| lehighvalley | StaticDataTable |
| leicester | StaticDataTable |
| leiden | StaticDataTable |
| leipzig | StaticDataTable |
| lethbridge | StaticDataTable |
| lexington | StaticDataTable |
| libya | StaticDataTable |
| lincoln | StaticDataTable |
| lisboa | StaticDataTable |
| lithuania | StaticDataTable |
| littleapple | StaticDataTable |
| littlerock | StaticDataTable |
| londonontario | StaticDataTable |
| londonsocialclub | StaticDataTable |
| longisland | StaticDataTable |
| longmont | StaticDataTable |
| louisiana | StaticDataTable |
| louisville | StaticDataTable |
| loveland | StaticDataTable |
| lubbock | StaticDataTable |
| lucknow | StaticDataTable |
| lund | StaticDataTable |
| luxembourg | StaticDataTable |
| lynchburg | StaticDataTable |
| lyon | StaticDataTable |
| macau | StaticDataTable |
| macedonia | StaticDataTable |
| macon | StaticDataTable |
| madisonwi | StaticDataTable |
| madrid | StaticDataTable |
| maharashtra | StaticDataTable |
| maine | StaticDataTable |
| malaysia | StaticDataTable |
| maldives | StaticDataTable |
| malmoe | StaticDataTable |
| malta | StaticDataTable |
| manhattan | StaticDataTable |
| manitoba | StaticDataTable |
| mankato | StaticDataTable |
| marietta | StaticDataTable |
| marin | StaticDataTable |
| markham | StaticDataTable |
| maroc | StaticDataTable |
| maryland | StaticDataTable |
| massachusetts | StaticDataTable |
| masterton | StaticDataTable |
| maui | StaticDataTable |
| mauritius | StaticDataTable |
| mckinney | StaticDataTable |
| medellin | StaticDataTable |
| medford | StaticDataTable |
| medfordma | StaticDataTable |
| medicinehat | StaticDataTable |
| melbourne | StaticDataTable |
| memphis | StaticDataTable |
| metaquebec | StaticDataTable |
| mexico | StaticDataTable |
| miami | StaticDataTable |
| michigan | StaticDataTable |
| midessa | StaticDataTable |
| milano | StaticDataTable |
| miltonkeynes | StaticDataTable |
| minneapolis | StaticDataTable |
| minnesota | StaticDataTable |
| mississauga | StaticDataTable |
| mississippi | StaticDataTable |
| missoula | StaticDataTable |
| missouri | StaticDataTable |
| mkd | StaticDataTable |
| moab | StaticDataTable |
| mobileal | StaticDataTable |
| moldova | StaticDataTable |
| moncton | StaticDataTable |
| mongolia | StaticDataTable |
| montana | StaticDataTable |
| montenegro | StaticDataTable |
| monterrey | StaticDataTable |
| montgomery | StaticDataTable |
| montgomerycountymd | StaticDataTable |
| montreal | StaticDataTable |
| morgantownwv | StaticDataTable |
| morocco | StaticDataTable |
| moscow | StaticDataTable |
| mumbai | StaticDataTable |
| munich | StaticDataTable |
| murfreesboro | StaticDataTable |
| muskegon | StaticDataTable |
| myanmar | StaticDataTable |
| myrtlebeach | StaticDataTable |
| nagpur | StaticDataTable |
| namibia | StaticDataTable |
| nanaimo | StaticDataTable |
| nantes | StaticDataTable |
| napa | StaticDataTable |
| naperville | StaticDataTable |
| naples_fl | StaticDataTable |
| napoli | StaticDataTable |
| nashville | StaticDataTable |
| nebraska | StaticDataTable |
| nederlands | StaticDataTable |
| nepa | StaticDataTable |
| nepal | StaticDataTable |
| nevada | StaticDataTable |
| newark | StaticDataTable |
| newbrunswickcanada | StaticDataTable |
| newburgh | StaticDataTable |
| newcastle | StaticDataTable |
| newcastleupontyne | StaticDataTable |
| newdelhi | StaticDataTable |
| newengland | StaticDataTable |
| newfoundland | StaticDataTable |
| newhampshire | StaticDataTable |
| newhaven | StaticDataTable |
| newjersey | StaticDataTable |
| newmarket | StaticDataTable |
| newmexico | StaticDataTable |
| neworleans | StaticDataTable |
| newportSW | StaticDataTable |
| newyork | StaticDataTable |
| newzealand | StaticDataTable |
| niagara | StaticDataTable |
| nicaragua | StaticDataTable |
| nigeria | StaticDataTable |
| nl | StaticDataTable |
| nordiccountries | StaticDataTable |
| norfolk | StaticDataTable |
| norge | StaticDataTable |
| normanok | StaticDataTable |
| northampton | StaticDataTable |
| northcarolina | StaticDataTable |
| northcounty | StaticDataTable |
| northdakota | StaticDataTable |
| northernireland | StaticDataTable |
| northkorea | StaticDataTable |
| norway | StaticDataTable |
| norwich | StaticDataTable |
| nottingham | StaticDataTable |
| nova | StaticDataTable |
| novascotia | StaticDataTable |
| nsw | StaticDataTable |
| nunavut | StaticDataTable |
| nwi | StaticDataTable |
| nyc | StaticDataTable |
| oakland | StaticDataTable |
| oakville | StaticDataTable |
| oaxaca | StaticDataTable |
| obx | StaticDataTable |
| ocala | StaticDataTable |
| oceancity | StaticDataTable |
| oceania | StaticDataTable |
| odisha | StaticDataTable |
| ogden | StaticDataTable |
| ohio | StaticDataTable |
| okc | StaticDataTable |
| okinawa | StaticDataTable |
| oklahoma | StaticDataTable |
| omaha | StaticDataTable |
| oman | StaticDataTable |
| ontario | StaticDataTable |
| oregon | StaticDataTable |
| oregoncoast | StaticDataTable |
| orlando | StaticDataTable |
| osaka | StaticDataTable |
| oslo | StaticDataTable |
| ottawa | StaticDataTable |
| oxford | StaticDataTable |
| pakistan | StaticDataTable |
| palestine | StaticDataTable |
| palmsprings | StaticDataTable |
| palmy | StaticDataTable |
| paloalto | StaticDataTable |
| panama | StaticDataTable |
| panamacity | StaticDataTable |
| paraguay | StaticDataTable |
| paris | StaticDataTable |
| parkcity | StaticDataTable |
| pei | StaticDataTable |
| pennsylvania | StaticDataTable |
| pensacola | StaticDataTable |
| peoriaIL | StaticDataTable |
| perth | StaticDataTable |
| peru | StaticDataTable |
| peterborough | StaticDataTable |
| philadelphia | StaticDataTable |
| philippines | StaticDataTable |
| phoenix | StaticDataTable |
| phuket | StaticDataTable |
| pittsburgh | StaticDataTable |
| plano | StaticDataTable |
| plattsburgh | StaticDataTable |
| playadelcarmen | StaticDataTable |
| plymouth | StaticDataTable |
| pokhara | StaticDataTable |
| poland | StaticDataTable |
| portland | StaticDataTable |
| portlandme | StaticDataTable |
| porto | StaticDataTable |
| portugal | StaticDataTable |
| prague | StaticDataTable |
| princegeorge | StaticDataTable |
| providence | StaticDataTable |
| provlux | StaticDataTable |
| pueblo | StaticDataTable |
| puertorico | StaticDataTable |
| pune | StaticDataTable |
| pyongyang | StaticDataTable |
| qatar | StaticDataTable |
| quadcities | StaticDataTable |
| quebec | StaticDataTable |
| quebeccity | StaticDataTable |
| queens | StaticDataTable |
| queensland | StaticDataTable |
| rajasthan | StaticDataTable |
| raleigh | StaticDataTable |
| rapidcity | StaticDataTable |
| reading | StaticDataTable |
| reddeer | StaticDataTable |
| redmond | StaticDataTable |
| redrivergorge | StaticDataTable |
| regina | StaticDataTable |
| reno | StaticDataTable |
| renton | StaticDataTable |
| republicaargentina | StaticDataTable |
| rhodeisland | StaticDataTable |
| richmondhill | StaticDataTable |
| riodejaneiro | StaticDataTable |
| riograndevalley | StaticDataTable |
| riverside | StaticDataTable |
| roanoke | StaticDataTable |
| rochester | StaticDataTable |
| rochestermn | StaticDataTable |
| rockford | StaticDataTable |
| rockland | StaticDataTable |
| rockvillemd | StaticDataTable |
| rojava | StaticDataTable |
| rolla | StaticDataTable |
| roma | StaticDataTable |
| romania | StaticDataTable |
| rome | StaticDataTable |
| rosario | StaticDataTable |
| roswell | StaticDataTable |
| rotterdam | StaticDataTable |
| roundrock | StaticDataTable |
| roxbury | StaticDataTable |
| ru | StaticDataTable |
| russia | StaticDataTable |
| rva | StaticDataTable |
| saintjohnnb | StaticDataTable |
| saintpaul | StaticDataTable |
| sakartvelo | StaticDataTable |
| salem | StaticDataTable |
| saltlakecity | StaticDataTable |
| san_angelo | StaticDataTable |
| sanantonio | StaticDataTable |
| sanmarcos | StaticDataTable |
| santaclarita | StaticDataTable |
| santafe | StaticDataTable |
| santarosa | StaticDataTable |
| santiago | StaticDataTable |
| saopaulo | StaticDataTable |
| sarasota | StaticDataTable |
| sarnia | StaticDataTable |
| saskatchewan | StaticDataTable |
| saskatoon | StaticDataTable |
| saudiarabia | StaticDataTable |
| savannah | StaticDataTable |
| scandinavia | StaticDataTable |
| scarborough | StaticDataTable |
| schenectady | StaticDataTable |
| scotland | StaticDataTable |
| scottsdale | StaticDataTable |
| seoul | StaticDataTable |
| serbia | StaticDataTable |
| shanghai | StaticDataTable |
| shenzhen | StaticDataTable |
| shreveport | StaticDataTable |
| siliconvalley | StaticDataTable |
| simivalley | StaticDataTable |
| singapore | StaticDataTable |
| siouxfalls | StaticDataTable |
| slo | StaticDataTable |
| slovakia | StaticDataTable |
| slovenia | StaticDataTable |
| somerville | StaticDataTable |
| south_korea | StaticDataTable |
| southafrica | StaticDataTable |
| southamerica | StaticDataTable |
| southampton | StaticDataTable |
| southcarolina | StaticDataTable |
| southdakota | StaticDataTable |
| southeastasia | StaticDataTable |
| southflorida | StaticDataTable |
| southjersey | StaticDataTable |
| southkorea | StaticDataTable |
| spain | StaticDataTable |
| spb | StaticDataTable |
| spokane | StaticDataTable |
| springfield | StaticDataTable |
| springfieldil | StaticDataTable |
| springfieldmo | StaticDataTable |
| squamish | StaticDataTable |
| srilanka | StaticDataTable |
| srpska | StaticDataTable |
| statenisland | StaticDataTable |
| staugustine | StaticDataTable |
| stcatharineson | StaticDataTable |
| stcharlesmo | StaticDataTable |
| stjohnsnl | StaticDataTable |
| stlouis | StaticDataTable |
| stockholm | StaticDataTable |
| stpetersburgfl | StaticDataTable |
| strasbourg | StaticDataTable |
| stuttgart | StaticDataTable |
| sudan | StaticDataTable |
| sudbury | StaticDataTable |
| sunnyvale | StaticDataTable |
| sunshinecoast | StaticDataTable |
| suomi | StaticDataTable |
| surrey | StaticDataTable |
| swansea | StaticDataTable |
| sweden | StaticDataTable |
| swfl | StaticDataTable |
| switzerland | StaticDataTable |
| sydney | StaticDataTable |
| syracuse | StaticDataTable |
| tacoma | StaticDataTable |
| tahoe | StaticDataTable |
| taiwan | StaticDataTable |
| tajikistan | StaticDataTable |
| tallahassee | StaticDataTable |
| tamilnadu | StaticDataTable |
| tampa | StaticDataTable |
| tampabay | StaticDataTable |
| tampere | StaticDataTable |
| tanzania | StaticDataTable |
| tasmania | StaticDataTable |
| temecula | StaticDataTable |
| tempe | StaticDataTable |
| tennessee | StaticDataTable |
| texas | StaticDataTable |
| thailand | StaticDataTable |
| thenetherlands | StaticDataTable |
| thetron | StaticDataTable |
| thewoodlands | StaticDataTable |
| thunderbay | StaticDataTable |
| tibet | StaticDataTable |
| ticos | StaticDataTable |
| tijuana | StaticDataTable |
| tirol | StaticDataTable |
| tlh | StaticDataTable |
| tokyo | StaticDataTable |
| toledo | StaticDataTable |
| topeka | StaticDataTable |
| toronto | StaticDataTable |
| torreon | StaticDataTable |
| toulouse | StaticDataTable |
| tours | StaticDataTable |
| townsville | StaticDataTable |
| tr | StaticDataTable |
| traversecity | StaticDataTable |
| tricities | StaticDataTable |
| tricitieswa | StaticDataTable |
| troy | StaticDataTable |
| tucson | StaticDataTable |
| tulsa | StaticDataTable |
| tulum | StaticDataTable |
| tunisia | StaticDataTable |
| turkey | StaticDataTable |
| tuscaloosa | StaticDataTable |
| twincities | StaticDataTable |
| twincitiessocial | StaticDataTable |
| tylertx | StaticDataTable |
| uae | StaticDataTable |
| ukraina | StaticDataTable |
| ukraine | StaticDataTable |
| unitedkingdom | StaticDataTable |
| unitedstatesofamerica | StaticDataTable |
| unitedstatesofindia | StaticDataTable |
| uppsala | StaticDataTable |
| upstate_new_york | StaticDataTable |
| uruguay | StaticDataTable |
| utah | StaticDataTable |
| utrecht | StaticDataTable |
| uttarakhand | StaticDataTable |
| uzbekistan | StaticDataTable |
| vail | StaticDataTable |
| valencia | StaticDataTable |
| valleyfield | StaticDataTable |
| vancouver | StaticDataTable |
| vancouverisland | StaticDataTable |
| vancouverwa | StaticDataTable |
| vaughan | StaticDataTable |
| vegas | StaticDataTable |
| venezia | StaticDataTable |
| venturacounty | StaticDataTable |
| vermont | StaticDataTable |
| victoriabc | StaticDataTable |
| vietnam | StaticDataTable |
| vinnitsa | StaticDataTable |
| virginia | StaticDataTable |
| virginiabeach | StaticDataTable |
| virginislands | StaticDataTable |
| viseu | StaticDataTable |
| vlaanderen | StaticDataTable |
| vzla | StaticDataTable |
| waco | StaticDataTable |
| wallonia | StaticDataTable |
| warsaw | StaticDataTable |
| washington | StaticDataTable |
| washingtondc | StaticDataTable |
| waterloo | StaticDataTable |
| wellington | StaticDataTable |
| westbengal | StaticDataTable |
| westchester | StaticDataTable |
| westchesterpa | StaticDataTable |
| westvirginia | StaticDataTable |
| whistler | StaticDataTable |
| wichita | StaticDataTable |
| wien | StaticDataTable |
| williamsburg | StaticDataTable |
| wilmington | StaticDataTable |
| wilmingtonDE | StaticDataTable |
| winchester | StaticDataTable |
| windsorontario | StaticDataTable |
| winnipeg | StaticDataTable |
| winstonsalem | StaticDataTable |
| wnc | StaticDataTable |
| wollongong | StaticDataTable |
| worcesterma | StaticDataTable |
| wrexham | StaticDataTable |
| yakima | StaticDataTable |
| yellowstone | StaticDataTable |
| yooper | StaticDataTable |
| yorkshire | StaticDataTable |
| yosemite | StaticDataTable |
| ypsi | StaticDataTable |
| yucatan | StaticDataTable |
| yukon | StaticDataTable |
| yuma | StaticDataTable |
| zambia | StaticDataTable |
| zimbabwe | StaticDataTable |
| zimnicea | StaticDataTable |
| zlin | StaticDataTable |
| zoetermeer | StaticDataTable |
| zonasul | StaticDataTable |
| zrce | StaticDataTable |
| zug | StaticDataTable |
| zurich | StaticDataTable |
| zutphen | StaticDataTable |
| zwickau | StaticDataTable |
| zwijndrecht | StaticDataTable |
| zwolle | StaticDataTable |
Schemas
| Name | Type |
|---|---|
| subreddit | RowStruct |
Source specification
from aorist import (
RowStruct,
MinioLocation,
WebLocation,
StaticTabularLayout,
ORCEncoding,
CSVEncoding,
SingleFileLayout,
RemoteStorage,
HiveTableStorage,
RemoteStorageSetup,
StaticDataTable,
DataSet,
default_tabular_schema,
attr_list,
PushshiftAPILocation,
PushshiftSubredditPostsAPILayout,
NewlineDelimitedJSONEncoding,
)
from aorist import attributes as attr
import json, os.path
attributes = attr_list([
attr.KeyStringIdentifier("id"),
attr.StringIdentifier("author"),
attr.StringIdentifier("subreddit"),
attr.POSIXTimestamp("created_utc"),
attr.FreeText("title"),
attr.FreeText("selftext", nullable=True),
])
subreddit_datum = RowStruct(
name="subreddit",
attributes=attributes,
)
subreddits = json.load(open(os.path.join(os.path.dirname(__file__), 'subreddits.json')))
# missing: australia_ (collision)
assets = {x: StaticDataTable(
name=x,
schema=default_tabular_schema(subreddit_datum),
setup=RemoteStorageSetup(
remote=RemoteStorage(
location=PushshiftAPILocation(subreddit=x),
layout=PushshiftSubredditPostsAPILayout(),
encoding=NewlineDelimitedJSONEncoding(),
),
),
tag=x,
) for x in subreddits if not x in {
'australia_', 'Canada',
}}
subreddits = DataSet(
name="local_subreddits",
description=(
"Large place-based subreddits, as per the "
"[Global List of Local Reddits](https://www.reddit.com/r/LocationReddits/wiki/index). "
"Data downloaded "
"from [Pushshift](https://pushshift.io/). "
"All subreddits had >= 1000 posts in Pushshift on April 3rd, 2021."
),
sourcePath=__file__,
datumTemplates=[subreddit_datum],
assets=assets,
)