Code to download data. Choose a dataset, then a table, and get code to download it as Pandas or Numpy.

hub > local_subreddits

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

NameType
01535StaticDataTable
01960StaticDataTable
06443StaticDataTable
12901StaticDataTable
219StaticDataTable
251StaticDataTable
3066StaticDataTable
321StaticDataTable
386StaticDataTable
407StaticDataTable
413StaticDataTable
44646StaticDataTable
609StaticDataTable
618StaticDataTable
757StaticDataTable
772StaticDataTable
863StaticDataTable
905StaticDataTable
909StaticDataTable
94901StaticDataTable
AdelaideStaticDataTable
AmsterdamStaticDataTable
AnaheimStaticDataTable
AnchorageStaticDataTable
AntarcticaStaticDataTable
ArubaStaticDataTable
AustinStaticDataTable
BakersfieldStaticDataTable
BalticStatesStaticDataTable
BayAreaStaticDataTable
BelfastStaticDataTable
BeloHorizonteStaticDataTable
BigBearStaticDataTable
BigBendTXStaticDataTable
BishopStaticDataTable
BreckenridgeStaticDataTable
BritainStaticDataTable
BuenzliStaticDataTable
CAR_StaticDataTable
CaribbeanStaticDataTable
CascadiaStaticDataTable
CatalunyaStaticDataTable
ChengduStaticDataTable
ChicoCAStaticDataTable
CoachellaValleyStaticDataTable
CoronaStaticDataTable
DaytonaBeachStaticDataTable
DominicanStaticDataTable
DorchesterStaticDataTable
EdinburghStaticDataTable
EdmontonStaticDataTable
EindhovenStaticDataTable
EnglandStaticDataTable
EssexStaticDataTable
EstadosUnidosStaticDataTable
ForestofBowlandStaticDataTable
FortMyersStaticDataTable
FortSaskatchewanStaticDataTable
FresnoStaticDataTable
GazaStaticDataTable
GlasgowStaticDataTable
GreeleyStaticDataTable
GuadalajaraStaticDataTable
HighDesertStaticDataTable
HuntingtonBeachStaticDataTable
InlandEmpireStaticDataTable
IrvineStaticDataTable
ItaliaStaticDataTable
KeyWestStaticDataTable
KingdomofSaudiArabiaStaticDataTable
KingstonOntarioStaticDataTable
KyotoStaticDataTable
LacombeStaticDataTable
LivermoreStaticDataTable
LiverpoolStaticDataTable
LoganStaticDataTable
LondonStaticDataTable
LongBeachStaticDataTable
LosAngelesStaticDataTable
ManausStaticDataTable
ManchesterStaticDataTable
MedfordMassStaticDataTable
MexicoCityStaticDataTable
MiddleEastStaticDataTable
MilwaukeeStaticDataTable
ModestoStaticDataTable
MontereyBayStaticDataTable
NOLAStaticDataTable
NearWestSuburbsStaticDataTable
NewBrunswickNJStaticDataTable
OlympiaStaticDataTable
OrangeCountyStaticDataTable
OshawaStaticDataTable
PacificNorthwestStaticDataTable
PaisleyStaticDataTable
PasadenaStaticDataTable
PattayaStaticDataTable
PolskaStaticDataTable
PortlandMaineStaticDataTable
PortsmouthStaticDataTable
ReddingStaticDataTable
Republica_ArgentinaStaticDataTable
RichmondBCStaticDataTable
RosevilleStaticDataTable
SFVStaticDataTable
SacramentoStaticDataTable
SalemMAStaticDataTable
SanDiegoStaticDataTable
SanFranciscoStaticDataTable
SanJoseStaticDataTable
SantaBarbaraStaticDataTable
SantaCruzStaticDataTable
SantamonicaStaticDataTable
SaultSteMarieStaticDataTable
ScrantonStaticDataTable
SeattleStaticDataTable
SeattleWAStaticDataTable
SheffieldStaticDataTable
SilverSpringStaticDataTable
SlovenijaStaticDataTable
SomaliaStaticDataTable
SouthAsiaStaticDataTable
SouthBayLAStaticDataTable
SouthBendStaticDataTable
StamfordCTStaticDataTable
SteubenvilleStaticDataTable
SyriaStaticDataTable
TarantoStaticDataTable
TheHagueStaticDataTable
TriangleStaticDataTable
TrinidadandTobagoStaticDataTable
UgandaStaticDataTable
VenturaStaticDataTable
VisaliaStaticDataTable
WalesStaticDataTable
WalthamStaticDataTable
WisconsinStaticDataTable
WyomingStaticDataTable
YemenStaticDataTable
YorkStaticDataTable
YoungstownStaticDataTable
ZionNPStaticDataTable
aachenStaticDataTable
aalborgStaticDataTable
aarhusStaticDataTable
abbotsfordStaticDataTable
aberdeenStaticDataTable
abudhabiStaticDataTable
acadianaStaticDataTable
adirondacksStaticDataTable
afghanistanStaticDataTable
africaStaticDataTable
ahmedabadStaticDataTable
aixmarseilleStaticDataTable
akronStaticDataTable
alabamaStaticDataTable
alamedaStaticDataTable
alaskaStaticDataTable
albaniaStaticDataTable
albanyStaticDataTable
albertaStaticDataTable
albuquerqueStaticDataTable
algeriaStaticDataTable
algonquinparkStaticDataTable
alpharettaStaticDataTable
amarilloStaticDataTable
americaStaticDataTable
amesStaticDataTable
andorraStaticDataTable
angolaStaticDataTable
ankaraStaticDataTable
annapolisStaticDataTable
annarborStaticDataTable
antwerpenStaticDataTable
argentinaStaticDataTable
arizonaStaticDataTable
arkansasStaticDataTable
arlingtonStaticDataTable
armeniaStaticDataTable
armenianStaticDataTable
aschaffenburgStaticDataTable
ashevilleStaticDataTable
asiaStaticDataTable
assamStaticDataTable
assyriaStaticDataTable
astoriaStaticDataTable
athensStaticDataTable
athensohioStaticDataTable
atlantaStaticDataTable
atlanticcityStaticDataTable
auburnStaticDataTable
aucklandStaticDataTable
augustaStaticDataTable
auroracoStaticDataTable
australiaStaticDataTable
austriaStaticDataTable
azerbaijanStaticDataTable
azoresStaticDataTable
bahamasStaticDataTable
bahrainStaticDataTable
baliStaticDataTable
balkansStaticDataTable
ballaratStaticDataTable
baltimoreStaticDataTable
bangaloreStaticDataTable
bangkokStaticDataTable
bangladeshStaticDataTable
barbadosStaticDataTable
barcelonaStaticDataTable
bariStaticDataTable
barrieStaticDataTable
bastroptxStaticDataTable
bathStaticDataTable
batonrougeStaticDataTable
beavertonStaticDataTable
beijingStaticDataTable
belarusStaticDataTable
belgiumStaticDataTable
belizeStaticDataTable
bellevueStaticDataTable
bellevuewaStaticDataTable
bellinghamStaticDataTable
bemidjiStaticDataTable
bendStaticDataTable
bergenStaticDataTable
berlinStaticDataTable
bermudaStaticDataTable
bethesdaStaticDataTable
bhutanStaticDataTable
bigislandStaticDataTable
bihStaticDataTable
biharStaticDataTable
billingsStaticDataTable
biloxiStaticDataTable
binghamtonStaticDataTable
birminghamStaticDataTable
bloomingtonStaticDataTable
bloomingtonnormalStaticDataTable
boiseStaticDataTable
boliviaStaticDataTable
bonnStaticDataTable
bosniaStaticDataTable
bostonStaticDataTable
botswanaStaticDataTable
boulderStaticDataTable
bournemouthStaticDataTable
bozemanStaticDataTable
bradentonStaticDataTable
bramptonStaticDataTable
brantfordStaticDataTable
brasilStaticDataTable
brazilStaticDataTable
bremenStaticDataTable
bretagneStaticDataTable
brightonStaticDataTable
brisbaneStaticDataTable
bristolStaticDataTable
britishcolumbiaStaticDataTable
brnoStaticDataTable
bronxStaticDataTable
brooklynStaticDataTable
browardStaticDataTable
brumStaticDataTable
bruneiStaticDataTable
brusselsStaticDataTable
buckscountypaStaticDataTable
bucovinaStaticDataTable
bucurestiStaticDataTable
budapestStaticDataTable
buenosairesStaticDataTable
buffaloStaticDataTable
bulgariaStaticDataTable
bullcityStaticDataTable
burbankStaticDataTable
burlingtonStaticDataTable
burlingtononStaticDataTable
burnabyStaticDataTable
bushwickStaticDataTable
cairnsStaticDataTable
calgaryStaticDataTable
californiaStaticDataTable
cambodiaStaticDataTable
cambridgeStaticDataTable
cambridgeMAStaticDataTable
canadaStaticDataTable
canberraStaticDataTable
cancunStaticDataTable
canterburyStaticDataTable
cantonStaticDataTable
capebretonStaticDataTable
capecodStaticDataTable
capetownStaticDataTable
cardiffStaticDataTable
cataloniaStaticDataTable
cebuStaticDataTable
cedarrapidsStaticDataTable
centralillinoisStaticDataTable
centralpaStaticDataTable
centralvalleyStaticDataTable
ceskyStaticDataTable
chandigarhStaticDataTable
chapelhillStaticDataTable
charlestonStaticDataTable
charlotteStaticDataTable
charlottesvilleStaticDataTable
chattanoogaStaticDataTable
chchStaticDataTable
chennaiStaticDataTable
chicagoStaticDataTable
chicagosuburbsStaticDataTable
chileStaticDataTable
chinaStaticDataTable
cincinnatiStaticDataTable
clarksvilleStaticDataTable
clearlakeStaticDataTable
clearwaterflStaticDataTable
clevelandStaticDataTable
clujStaticDataTable
coeurdaleneStaticDataTable
cologneStaticDataTable
colombiaStaticDataTable
coloradoStaticDataTable
coloradospringsStaticDataTable
columbiamdStaticDataTable
columbiamoStaticDataTable
columbusStaticDataTable
columbusgaStaticDataTable
comoxvalleyStaticDataTable
congoStaticDataTable
connecticutStaticDataTable
copenhagenStaticDataTable
cordobaStaticDataTable
corkStaticDataTable
cornwallStaticDataTable
corpusStaticDataTable
corvallisStaticDataTable
costa_ricaStaticDataTable
coventryStaticDataTable
croatiaStaticDataTable
cubaStaticDataTable
curitibaStaticDataTable
cymruStaticDataTable
cyprusStaticDataTable
czechStaticDataTable
dachschadenStaticDataTable
daejeonStaticDataTable
dallasStaticDataTable
dartmoorStaticDataTable
darwinStaticDataTable
davaoStaticDataTable
daytonStaticDataTable
deStaticDataTable
delawareStaticDataTable
delhiStaticDataTable
denmarkStaticDataTable
dentonStaticDataTable
denverStaticDataTable
desmoinesStaticDataTable
destinStaticDataTable
detroitStaticDataTable
deutschlandStaticDataTable
devonukStaticDataTable
dhakaStaticDataTable
downriverStaticDataTable
dresdenStaticDataTable
dubaiStaticDataTable
dublinStaticDataTable
dubrovnikStaticDataTable
duesseldorfStaticDataTable
duluthStaticDataTable
dundeeStaticDataTable
dunedinStaticDataTable
durangoStaticDataTable
durbanStaticDataTable
durhamStaticDataTable
eastbayStaticDataTable
eastsideStaticDataTable
ecuadorStaticDataTable
eestiStaticDataTable
egyptStaticDataTable
elkgroveStaticDataTable
elpasoStaticDataTable
elsalvadorStaticDataTable
erieStaticDataTable
eritreaStaticDataTable
esStaticDataTable
escondidoStaticDataTable
espanaStaticDataTable
ethiopiaStaticDataTable
eugeneStaticDataTable
europeStaticDataTable
europeanfederalistsStaticDataTable
evansvilleStaticDataTable
everettStaticDataTable
exeterStaticDataTable
fairbanksStaticDataTable
fargoStaticDataTable
faroeislandsStaticDataTable
fayettenamStaticDataTable
fayettevilleStaticDataTable
fijianStaticDataTable
finlandStaticDataTable
firstnationsStaticDataTable
flagstaffStaticDataTable
flintStaticDataTable
floridaStaticDataTable
floridakeysStaticDataTable
fortcollinsStaticDataTable
fortlauderdaleStaticDataTable
fortwayneStaticDataTable
fortworthStaticDataTable
franceStaticDataTable
frankfurtStaticDataTable
frederickmdStaticDataTable
fredericksburgStaticDataTable
frederictonStaticDataTable
freiburgStaticDataTable
freisingStaticDataTable
fremontStaticDataTable
friscoStaticDataTable
fukuokaStaticDataTable
galizaStaticDataTable
galvestonStaticDataTable
galwayStaticDataTable
gasteizStaticDataTable
gatineauStaticDataTable
geelongStaticDataTable
genevaStaticDataTable
gentStaticDataTable
georgiaStaticDataTable
germanyStaticDataTable
ghanaStaticDataTable
gifhornStaticDataTable
glacierStaticDataTable
glendaleStaticDataTable
gnvStaticDataTable
goaStaticDataTable
goldcoastStaticDataTable
gothenburgStaticDataTable
grandcanyonStaticDataTable
grandeprairieStaticDataTable
grandjunctionStaticDataTable
grandrapidsStaticDataTable
grazStaticDataTable
greeceStaticDataTable
greekredditStaticDataTable
greenbayStaticDataTable
greenlandStaticDataTable
greenvilleStaticDataTable
greifswaldStaticDataTable
groningenStaticDataTable
grossepointeStaticDataTable
gsoStaticDataTable
guamStaticDataTable
guangzhouStaticDataTable
guatemalaStaticDataTable
guelphStaticDataTable
guernseyStaticDataTable
guyanaStaticDataTable
gwangjuStaticDataTable
gwinnettStaticDataTable
hagerstownStaticDataTable
haitiStaticDataTable
halifaxStaticDataTable
hamburgStaticDataTable
hamiltonStaticDataTable
hamptonroadsStaticDataTable
hannoverStaticDataTable
harrisburgStaticDataTable
harrisonburgStaticDataTable
hartfordStaticDataTable
hattiesburgStaticDataTable
hawaiiStaticDataTable
heidelbergStaticDataTable
helsinkiStaticDataTable
hillsboroStaticDataTable
hobartStaticDataTable
hobokenStaticDataTable
hondurasStaticDataTable
hongkongStaticDataTable
honoluluStaticDataTable
houstonStaticDataTable
huStaticDataTable
hudsonvalleyStaticDataTable
hullStaticDataTable
humboldtStaticDataTable
hungaryStaticDataTable
huntsvillealabamaStaticDataTable
hyderabadStaticDataTable
ibizaStaticDataTable
icelandStaticDataTable
idahoStaticDataTable
illinoisStaticDataTable
indiaStaticDataTable
indianaStaticDataTable
indianapolisStaticDataTable
indonesiaStaticDataTable
iowaStaticDataTable
iowacityStaticDataTable
ipswichukStaticDataTable
iranStaticDataTable
iranianStaticDataTable
iraqStaticDataTable
irelandStaticDataTable
islamabadStaticDataTable
isleofmanStaticDataTable
israelStaticDataTable
istanbulStaticDataTable
itStaticDataTable
italyStaticDataTable
ithacaStaticDataTable
izmirStaticDataTable
jaStaticDataTable
jacksonmsStaticDataTable
jacksonvilleStaticDataTable
jaipurStaticDataTable
jakartaStaticDataTable
jamaicaStaticDataTable
japanStaticDataTable
jerseycityStaticDataTable
johannesburgStaticDataTable
joplinmoStaticDataTable
jordanStaticDataTable
joshuatreeStaticDataTable
juneauStaticDataTable
kaerntenStaticDataTable
kamloopsStaticDataTable
kansasStaticDataTable
kansascityStaticDataTable
kaposvarStaticDataTable
karachiStaticDataTable
karnatakaStaticDataTable
kashmirStaticDataTable
kauaiStaticDataTable
kazakhstanStaticDataTable
kelownaStaticDataTable
kennesawStaticDataTable
kenoshaStaticDataTable
kentuckyStaticDataTable
kenyaStaticDataTable
keralaStaticDataTable
kitchenerStaticDataTable
kitsapStaticDataTable
knoxvilleStaticDataTable
kolkataStaticDataTable
koreaStaticDataTable
kosovoStaticDataTable
krakowStaticDataTable
kualalumpurStaticDataTable
kurdistanStaticDataTable
kuwaitStaticDataTable
kyrgyzstanStaticDataTable
kzooStaticDataTable
lacrossewiStaticDataTable
lafayetteStaticDataTable
lagosStaticDataTable
lahoreStaticDataTable
lakecharlesStaticDataTable
lakelandStaticDataTable
lalagunaStaticDataTable
lancasterStaticDataTable
lansingStaticDataTable
laosStaticDataTable
laramieStaticDataTable
laredoStaticDataTable
lascrucesStaticDataTable
lasvegasStaticDataTable
latinamericaStaticDataTable
latinoamericaStaticDataTable
latviaStaticDataTable
lawrenceStaticDataTable
lebanonStaticDataTable
leedsStaticDataTable
lehighvalleyStaticDataTable
leicesterStaticDataTable
leidenStaticDataTable
leipzigStaticDataTable
lethbridgeStaticDataTable
lexingtonStaticDataTable
libyaStaticDataTable
lincolnStaticDataTable
lisboaStaticDataTable
lithuaniaStaticDataTable
littleappleStaticDataTable
littlerockStaticDataTable
londonontarioStaticDataTable
londonsocialclubStaticDataTable
longislandStaticDataTable
longmontStaticDataTable
louisianaStaticDataTable
louisvilleStaticDataTable
lovelandStaticDataTable
lubbockStaticDataTable
lucknowStaticDataTable
lundStaticDataTable
luxembourgStaticDataTable
lynchburgStaticDataTable
lyonStaticDataTable
macauStaticDataTable
macedoniaStaticDataTable
maconStaticDataTable
madisonwiStaticDataTable
madridStaticDataTable
maharashtraStaticDataTable
maineStaticDataTable
malaysiaStaticDataTable
maldivesStaticDataTable
malmoeStaticDataTable
maltaStaticDataTable
manhattanStaticDataTable
manitobaStaticDataTable
mankatoStaticDataTable
mariettaStaticDataTable
marinStaticDataTable
markhamStaticDataTable
marocStaticDataTable
marylandStaticDataTable
massachusettsStaticDataTable
mastertonStaticDataTable
mauiStaticDataTable
mauritiusStaticDataTable
mckinneyStaticDataTable
medellinStaticDataTable
medfordStaticDataTable
medfordmaStaticDataTable
medicinehatStaticDataTable
melbourneStaticDataTable
memphisStaticDataTable
metaquebecStaticDataTable
mexicoStaticDataTable
miamiStaticDataTable
michiganStaticDataTable
midessaStaticDataTable
milanoStaticDataTable
miltonkeynesStaticDataTable
minneapolisStaticDataTable
minnesotaStaticDataTable
mississaugaStaticDataTable
mississippiStaticDataTable
missoulaStaticDataTable
missouriStaticDataTable
mkdStaticDataTable
moabStaticDataTable
mobilealStaticDataTable
moldovaStaticDataTable
monctonStaticDataTable
mongoliaStaticDataTable
montanaStaticDataTable
montenegroStaticDataTable
monterreyStaticDataTable
montgomeryStaticDataTable
montgomerycountymdStaticDataTable
montrealStaticDataTable
morgantownwvStaticDataTable
moroccoStaticDataTable
moscowStaticDataTable
mumbaiStaticDataTable
munichStaticDataTable
murfreesboroStaticDataTable
muskegonStaticDataTable
myanmarStaticDataTable
myrtlebeachStaticDataTable
nagpurStaticDataTable
namibiaStaticDataTable
nanaimoStaticDataTable
nantesStaticDataTable
napaStaticDataTable
napervilleStaticDataTable
naples_flStaticDataTable
napoliStaticDataTable
nashvilleStaticDataTable
nebraskaStaticDataTable
nederlandsStaticDataTable
nepaStaticDataTable
nepalStaticDataTable
nevadaStaticDataTable
newarkStaticDataTable
newbrunswickcanadaStaticDataTable
newburghStaticDataTable
newcastleStaticDataTable
newcastleupontyneStaticDataTable
newdelhiStaticDataTable
newenglandStaticDataTable
newfoundlandStaticDataTable
newhampshireStaticDataTable
newhavenStaticDataTable
newjerseyStaticDataTable
newmarketStaticDataTable
newmexicoStaticDataTable
neworleansStaticDataTable
newportSWStaticDataTable
newyorkStaticDataTable
newzealandStaticDataTable
niagaraStaticDataTable
nicaraguaStaticDataTable
nigeriaStaticDataTable
nlStaticDataTable
nordiccountriesStaticDataTable
norfolkStaticDataTable
norgeStaticDataTable
normanokStaticDataTable
northamptonStaticDataTable
northcarolinaStaticDataTable
northcountyStaticDataTable
northdakotaStaticDataTable
northernirelandStaticDataTable
northkoreaStaticDataTable
norwayStaticDataTable
norwichStaticDataTable
nottinghamStaticDataTable
novaStaticDataTable
novascotiaStaticDataTable
nswStaticDataTable
nunavutStaticDataTable
nwiStaticDataTable
nycStaticDataTable
oaklandStaticDataTable
oakvilleStaticDataTable
oaxacaStaticDataTable
obxStaticDataTable
ocalaStaticDataTable
oceancityStaticDataTable
oceaniaStaticDataTable
odishaStaticDataTable
ogdenStaticDataTable
ohioStaticDataTable
okcStaticDataTable
okinawaStaticDataTable
oklahomaStaticDataTable
omahaStaticDataTable
omanStaticDataTable
ontarioStaticDataTable
oregonStaticDataTable
oregoncoastStaticDataTable
orlandoStaticDataTable
osakaStaticDataTable
osloStaticDataTable
ottawaStaticDataTable
oxfordStaticDataTable
pakistanStaticDataTable
palestineStaticDataTable
palmspringsStaticDataTable
palmyStaticDataTable
paloaltoStaticDataTable
panamaStaticDataTable
panamacityStaticDataTable
paraguayStaticDataTable
parisStaticDataTable
parkcityStaticDataTable
peiStaticDataTable
pennsylvaniaStaticDataTable
pensacolaStaticDataTable
peoriaILStaticDataTable
perthStaticDataTable
peruStaticDataTable
peterboroughStaticDataTable
philadelphiaStaticDataTable
philippinesStaticDataTable
phoenixStaticDataTable
phuketStaticDataTable
pittsburghStaticDataTable
planoStaticDataTable
plattsburghStaticDataTable
playadelcarmenStaticDataTable
plymouthStaticDataTable
pokharaStaticDataTable
polandStaticDataTable
portlandStaticDataTable
portlandmeStaticDataTable
portoStaticDataTable
portugalStaticDataTable
pragueStaticDataTable
princegeorgeStaticDataTable
providenceStaticDataTable
provluxStaticDataTable
puebloStaticDataTable
puertoricoStaticDataTable
puneStaticDataTable
pyongyangStaticDataTable
qatarStaticDataTable
quadcitiesStaticDataTable
quebecStaticDataTable
quebeccityStaticDataTable
queensStaticDataTable
queenslandStaticDataTable
rajasthanStaticDataTable
raleighStaticDataTable
rapidcityStaticDataTable
readingStaticDataTable
reddeerStaticDataTable
redmondStaticDataTable
redrivergorgeStaticDataTable
reginaStaticDataTable
renoStaticDataTable
rentonStaticDataTable
republicaargentinaStaticDataTable
rhodeislandStaticDataTable
richmondhillStaticDataTable
riodejaneiroStaticDataTable
riograndevalleyStaticDataTable
riversideStaticDataTable
roanokeStaticDataTable
rochesterStaticDataTable
rochestermnStaticDataTable
rockfordStaticDataTable
rocklandStaticDataTable
rockvillemdStaticDataTable
rojavaStaticDataTable
rollaStaticDataTable
romaStaticDataTable
romaniaStaticDataTable
romeStaticDataTable
rosarioStaticDataTable
roswellStaticDataTable
rotterdamStaticDataTable
roundrockStaticDataTable
roxburyStaticDataTable
ruStaticDataTable
russiaStaticDataTable
rvaStaticDataTable
saintjohnnbStaticDataTable
saintpaulStaticDataTable
sakartveloStaticDataTable
salemStaticDataTable
saltlakecityStaticDataTable
san_angeloStaticDataTable
sanantonioStaticDataTable
sanmarcosStaticDataTable
santaclaritaStaticDataTable
santafeStaticDataTable
santarosaStaticDataTable
santiagoStaticDataTable
saopauloStaticDataTable
sarasotaStaticDataTable
sarniaStaticDataTable
saskatchewanStaticDataTable
saskatoonStaticDataTable
saudiarabiaStaticDataTable
savannahStaticDataTable
scandinaviaStaticDataTable
scarboroughStaticDataTable
schenectadyStaticDataTable
scotlandStaticDataTable
scottsdaleStaticDataTable
seoulStaticDataTable
serbiaStaticDataTable
shanghaiStaticDataTable
shenzhenStaticDataTable
shreveportStaticDataTable
siliconvalleyStaticDataTable
simivalleyStaticDataTable
singaporeStaticDataTable
siouxfallsStaticDataTable
sloStaticDataTable
slovakiaStaticDataTable
sloveniaStaticDataTable
somervilleStaticDataTable
south_koreaStaticDataTable
southafricaStaticDataTable
southamericaStaticDataTable
southamptonStaticDataTable
southcarolinaStaticDataTable
southdakotaStaticDataTable
southeastasiaStaticDataTable
southfloridaStaticDataTable
southjerseyStaticDataTable
southkoreaStaticDataTable
spainStaticDataTable
spbStaticDataTable
spokaneStaticDataTable
springfieldStaticDataTable
springfieldilStaticDataTable
springfieldmoStaticDataTable
squamishStaticDataTable
srilankaStaticDataTable
srpskaStaticDataTable
statenislandStaticDataTable
staugustineStaticDataTable
stcatharinesonStaticDataTable
stcharlesmoStaticDataTable
stjohnsnlStaticDataTable
stlouisStaticDataTable
stockholmStaticDataTable
stpetersburgflStaticDataTable
strasbourgStaticDataTable
stuttgartStaticDataTable
sudanStaticDataTable
sudburyStaticDataTable
sunnyvaleStaticDataTable
sunshinecoastStaticDataTable
suomiStaticDataTable
surreyStaticDataTable
swanseaStaticDataTable
swedenStaticDataTable
swflStaticDataTable
switzerlandStaticDataTable
sydneyStaticDataTable
syracuseStaticDataTable
tacomaStaticDataTable
tahoeStaticDataTable
taiwanStaticDataTable
tajikistanStaticDataTable
tallahasseeStaticDataTable
tamilnaduStaticDataTable
tampaStaticDataTable
tampabayStaticDataTable
tampereStaticDataTable
tanzaniaStaticDataTable
tasmaniaStaticDataTable
temeculaStaticDataTable
tempeStaticDataTable
tennesseeStaticDataTable
texasStaticDataTable
thailandStaticDataTable
thenetherlandsStaticDataTable
thetronStaticDataTable
thewoodlandsStaticDataTable
thunderbayStaticDataTable
tibetStaticDataTable
ticosStaticDataTable
tijuanaStaticDataTable
tirolStaticDataTable
tlhStaticDataTable
tokyoStaticDataTable
toledoStaticDataTable
topekaStaticDataTable
torontoStaticDataTable
torreonStaticDataTable
toulouseStaticDataTable
toursStaticDataTable
townsvilleStaticDataTable
trStaticDataTable
traversecityStaticDataTable
tricitiesStaticDataTable
tricitieswaStaticDataTable
troyStaticDataTable
tucsonStaticDataTable
tulsaStaticDataTable
tulumStaticDataTable
tunisiaStaticDataTable
turkeyStaticDataTable
tuscaloosaStaticDataTable
twincitiesStaticDataTable
twincitiessocialStaticDataTable
tylertxStaticDataTable
uaeStaticDataTable
ukrainaStaticDataTable
ukraineStaticDataTable
unitedkingdomStaticDataTable
unitedstatesofamericaStaticDataTable
unitedstatesofindiaStaticDataTable
uppsalaStaticDataTable
upstate_new_yorkStaticDataTable
uruguayStaticDataTable
utahStaticDataTable
utrechtStaticDataTable
uttarakhandStaticDataTable
uzbekistanStaticDataTable
vailStaticDataTable
valenciaStaticDataTable
valleyfieldStaticDataTable
vancouverStaticDataTable
vancouverislandStaticDataTable
vancouverwaStaticDataTable
vaughanStaticDataTable
vegasStaticDataTable
veneziaStaticDataTable
venturacountyStaticDataTable
vermontStaticDataTable
victoriabcStaticDataTable
vietnamStaticDataTable
vinnitsaStaticDataTable
virginiaStaticDataTable
virginiabeachStaticDataTable
virginislandsStaticDataTable
viseuStaticDataTable
vlaanderenStaticDataTable
vzlaStaticDataTable
wacoStaticDataTable
walloniaStaticDataTable
warsawStaticDataTable
washingtonStaticDataTable
washingtondcStaticDataTable
waterlooStaticDataTable
wellingtonStaticDataTable
westbengalStaticDataTable
westchesterStaticDataTable
westchesterpaStaticDataTable
westvirginiaStaticDataTable
whistlerStaticDataTable
wichitaStaticDataTable
wienStaticDataTable
williamsburgStaticDataTable
wilmingtonStaticDataTable
wilmingtonDEStaticDataTable
winchesterStaticDataTable
windsorontarioStaticDataTable
winnipegStaticDataTable
winstonsalemStaticDataTable
wncStaticDataTable
wollongongStaticDataTable
worcestermaStaticDataTable
wrexhamStaticDataTable
yakimaStaticDataTable
yellowstoneStaticDataTable
yooperStaticDataTable
yorkshireStaticDataTable
yosemiteStaticDataTable
ypsiStaticDataTable
yucatanStaticDataTable
yukonStaticDataTable
yumaStaticDataTable
zambiaStaticDataTable
zimbabweStaticDataTable
zimniceaStaticDataTable
zlinStaticDataTable
zoetermeerStaticDataTable
zonasulStaticDataTable
zrceStaticDataTable
zugStaticDataTable
zurichStaticDataTable
zutphenStaticDataTable
zwickauStaticDataTable
zwijndrechtStaticDataTable
zwolleStaticDataTable

Schemas

NameType
subredditRowStruct

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

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('scienz/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,
)