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,
)