Skip to content

Latest commit

 

History

History
826 lines (815 loc) · 46.4 KB

readme.md

File metadata and controls

826 lines (815 loc) · 46.4 KB

Missed Connections API

a crawler, redis store, and flask api for missed connections

the url endpoint

currently:

http://54.205.111.185:5000/

the database

redis is not a typical database, it's a key/value store. to keep the api as simple as possible, the keys are unique combinations of city and sexual orientation (m4w, w4m, m4m, m4w, etc), and the values are lists of json blobs, with each blob corresponding to a missed connection.

how do I query the database?

Yes, you may be thinking this:

img

But mc-api is pretty easy to query. the url format is this

/?city=<city>&orientation=<orientation>&start=<start_ts>&end=<end_ts>&order=<order>

For example:
http://54.205.111.185:5000/?city=orange-county&orientation=m4w&start=0&end=10000000000&order=desc

If you specify orientation=all the api will return all missed connections in a given city.

You can also retrieve a random missed connection at:
http://54.205.111.185:5000/random

Data Dictionary

gender / target:

  • m = man
  • w = woman
  • t = transexual

orientation:

possible_values:

None
t4t
t4tt
t4m
t4w
t4mm
t4ww
t4wm
t4mw
tt4t
tt4tt
tt4m
tt4w
tt4mm
tt4ww
tt4wm
tt4mw
m4t
m4tt
m4m
m4w
m4mm
m4ww
m4wm
m4mw
w4t
w4tt
w4m
w4w
w4mm
w4ww
w4wm
w4mw
mm4t
mm4tt
mm4m
mm4w
mm4mm
mm4ww
mm4wm
mm4mw
ww4t
ww4tt
ww4m
ww4w
ww4mm
ww4ww
ww4wm
ww4mw
wm4t
wm4tt
wm4m
wm4w
wm4mm
wm4ww
wm4wm
wm4mw
mw4t
mw4tt
mw4m
mw4w
mw4mm
mw4ww
mw4wm
mw4mw

city (with links to rss feeds)

You can also find a csv of these here


auburn
birmingham
dothan
florence-muscle-shoals
gadsden-anniston
huntsville-decatur
mobile
montgomery
tuscaloosa
anchorage-mat-su
fairbanks
kenai-peninsula
southeast-alaska
flagstaff-sedona
mohave-county
phoenix
prescott
show-low
sierra-vista
tucson
yuma
fayetteville
fort-smith
jonesboro
little-rock
texarkana
bakersfield
chico
fresno-madera
gold-country
hanford-corcoran
humboldt-county
imperial-county
inland-empire
los-angeles
mendocino-county
merced
modesto
monterey-bay
orange-county
palm-springs
redding
sacramento
san-diego
san-francisco-bay-area
san-luis-obispo
santa-barbara
santa-maria
siskiyou-county
stockton
susanville
ventura-county
visalia-tulare
yuba-sutter
boulder
colorado-springs
denver
eastern-co
fort-collins-north-co
high-rockies
pueblo
western-slope
eastern-ct
hartford
new-haven
northwest-ct
delaware
washington
daytona-beach
florida-keys
fort-lauderdale
ft-myers-sw-florida
gainesville
heartland-florida
jacksonville
lakeland
north-central-fl
ocala
okaloosa-walton
orlando
panama-city
pensacola
sarasota-bradenton
south-florida
space-coast
st-augustine
tallahassee
tampa-bay-area
treasure-coast
west-palm-beach
albany
athens
atlanta
augusta
brunswick
columbus
macon-warner-robins
northwest-ga
savannah-hinesville
statesboro
valdosta
hawaii
boise
east-idaho
lewiston-clarkston
twin-falls
bloomington-normal
champaign-urbana
chicago
decatur
la-salle-co
mattoon-charleston
peoria
rockford
southern-illinois
springfield
western-il
bloomington
evansville
fort-wayne
indianapolis
kokomo
lafayette-west-lafayette
muncie-anderson
richmond
south-bend-michiana
terre-haute
ames
cedar-rapids
des-moines
dubuque
fort-dodge
iowa-city
mason-city
quad-cities
sioux-city
southeast-ia
waterloo-cedar-falls
lawrence
manhattan
northwest-ks
salina
southeast-ks
southwest-ks
topeka
wichita
bowling-green
eastern-kentucky
lexington
louisville
owensboro
western-ky
baton-rouge
central-louisiana
houma
lafayette
lake-charles
monroe
new-orleans
shreveport
maine
annapolis
baltimore
eastern-shore
frederick
southern-maryland
western-maryland
boston
cape-cod-islands
south-coast
western-massachusetts
worcester-central-ma
ann-arbor
battle-creek
central-michigan
detroit-metro
flint
grand-rapids
holland
jackson
kalamazoo
lansing
monroe
muskegon
northern-michigan
port-huron
saginaw-midland-baycity
southwest-michigan
the-thumb
upper-peninsula
bemidji
brainerd
duluth-superior
mankato
minneapolis-st-paul
rochester
southwest-mn
st-cloud
gulfport-biloxi
hattiesburg
jackson
meridian
north-mississippi
southwest-ms
columbia-jeff-city
joplin
kansas-city
kirksville
lake-of-the-ozarks
southeast-missouri
springfield
st-joseph
st-louis
billings
bozeman
butte
great-falls
helena
kalispell
missoula
montana-(old)
grand-island
lincoln
north-platte
omaha-council-bluffs
scottsbluff-panhandle
elko
las-vegas
reno-tahoe
new-hampshire
central-nj
jersey-shore
north-jersey
south-jersey
albuquerque
clovis-portales
farmington
las-cruces
roswell-carlsbad
santa-fe-taos
albany
binghamton
buffalo
catskills
chautauqua
elmira-corning
finger-lakes
glens-falls
hudson-valley
ithaca
long-island
new-york-city
oneonta
plattsburgh-adirondacks
potsdam-canton-massena
rochester
syracuse
twin-tiers-ny-pa
utica-rome-oneida
watertown
asheville
boone
charlotte
eastern-nc
fayetteville
greensboro
hickory-lenoir
jacksonville
outer-banks
raleigh-durham-ch
wilmington
winston-salem
bismarck
fargo-moorhead
grand-forks
north-dakota
akron-canton
ashtabula
athens
chillicothe
cincinnati
cleveland
columbus
dayton-springfield
lima-findlay
mansfield
sandusky
toledo
tuscarawas-co
youngstown
zanesville-cambridge
lawton
northwest-ok
oklahoma-city
stillwater
tulsa
bend
corvallis-albany
east-oregon
eugene
klamath-falls
medford-ashland
oregon-coast
portland
roseburg
salem
altoona-johnstown
cumberland-valley
erie
harrisburg
lancaster
lehigh-valley
meadville
philadelphia
pittsburgh
poconos
reading
scranton-wilkes-barre
state-college
williamsport
york
rhode-island
charleston
columbia
florence
greenville-upstate
hilton-head
myrtle-beach
northeast-sd
pierre-central-sd
rapid-city-west-sd
sioux-falls-se-sd
south-dakota
chattanooga
clarksville
cookeville
jackson
knoxville
memphis
nashville
tri-cities
abilene
amarillo
austin
beaumont-port-arthur
brownsville
college-station
corpus-christi
dallas-fort-worth
deep-east-texas
del-rio-eagle-pass
el-paso
galveston
houston
killeen-temple-ft-hood
laredo
lubbock
mcallen-edinburg
odessa-midland
san-angelo
san-antonio
san-marcos
southwest-tx
texoma
tyler-east-tx
victoria
waco
wichita-falls
logan
ogden-clearfield
provo-orem
salt-lake-city
st-george
vermont
charlottesville
danville
fredericksburg
hampton-roads
harrisonburg
lynchburg
new-river-valley
richmond
roanoke
southwest-va
winchester
bellingham
kennewick-pasco-richland
moses-lake
olympic-peninsula
pullman-moscow
seattle-tacoma
skagit-island-sji
spokane-coeur-d'alene
wenatchee
yakima
charleston
eastern-panhandle
huntington-ashland
morgantown
northern-panhandle
parkersburg-marietta
southern-wv
west-virginia-(old)
appleton-oshkosh-fdl
eau-claire
green-bay
janesville
kenosha-racine
la-crosse
madison
milwaukee
northern-wi
sheboygan
wausau
wyoming
guam-micronesia
puerto-rico
u-s-virgin-islands
calgary
edmonton
ft-mcmurray
lethbridge
medicine-hat
peace-river-country
red-deer
cariboo
comox-valley
fraser-valley
kamloops
kelowna-okanagan
kootenays
nanaimo
prince-george
skeena-bulkley
sunshine-coast
vancouver
victoria
whistler
winnipeg
new-brunswick
st-john's
territories
yellowknife
halifax
barrie
belleville
brantford-woodstock
chatham-kent
cornwall
guelph
hamilton-burlington
kingston
kitchener-waterloo-cambridge
london
niagara-region
ottawa-hull-gatineau
owen-sound
peterborough
sarnia
sault-ste-marie
sudbury
thunder-bay
toronto
windsor
prince-edward-island
montreal
quebec-city
saguenay
sherbrooke
trois-rivieres
regina
saskatoon
whitehorse
vienna
belgium
bulgaria
croatia
prague
copenhagen
finland
bordeaux
brittany
grenoble
lille
loire-valley
lyon
marseille
montpellier
nice-cote-d'azur
normandy
paris
strasbourg
toulouse
berlin
bremen
cologne
dresden
dusseldorf
essen-ruhr
frankfurt
hamburg
hannover
heidelberg
kaiserslautern
leipzig
munich
nuremberg
stuttgart
greece
budapest
reykjavik
dublin
bologna
florence-tuscany
genoa
milan
napoli-campania
perugia
rome
sardinia
sicilia
torino
venice-veneto
luxembourg
amsterdam-randstad
norway
poland
faro-algarve
lisbon
porto
romania
moscow
st-petersburg
alicante
baleares
barcelona
bilbao
cadiz
canarias
granada
madrid
malaga
sevilla
valencia
sweden
basel
bern
geneva
lausanne
zurich
turkey
ukraine
aberdeen
bath
belfast
birmingham-west-mids
brighton
bristol
"cambridge
cardiff-wales
coventry
derby
devon-&-cornwall
dundee
east-anglia
east-midlands
edinburgh
essex
glasgow
hampshire
kent
leeds
liverpool
london
manchester
newcastle-ne-england
nottingham
oxford
sheffield
bangladesh
beijing
chengdu
chongqing
dalian
guangzhou
hangzhou
nanjing
shanghai
shenyang
shenzhen
wuhan
xi'an
hong-kong
ahmedabad
bangalore
bhubaneswar
chandigarh
chennai-(madras)
delhi
goa
hyderabad
indore
jaipur
kerala
kolkata-(calcutta)
lucknow
mumbai
pune
surat-surat
indonesia
iran
iraq
haifa
jerusalem
tel-aviv
west-bank
fukuoka
hiroshima
nagoya
okinawa
osaka-kobe-kyoto
sapporo
sendai
tokyo
seoul
kuwait
"beirut
malaysia
pakistan
bacolod
bicol-region
cagayan-de-oro
cebu
davao-city
iloilo
manila
pampanga
zamboanga
singapore
taiwan
thailand
united-arab-emirates
vietnam
adelaide
brisbane
cairns
canberra
darwin
gold-coast
melbourne
"newcastle
perth
sydney
tasmania
wollongong
auckland
christchurch
dunedin
wellington
caribbean-islands
buenos-aires
bolivia
belo-horizonte
brasilia
curitiba
fortaleza
porto-alegre
recife
rio-de-janeiro
"salvador
sao-paulo
chile
colombia
costa-rica
dominican-republic
ecuador
el-salvador
guatemala
acapulco
baja-california-sur
chihuahua
ciudad-juarez
guadalajara
guanajuato
hermosillo
mazatlan
mexico-city
monterrey
oaxaca
puebla
puerto-vallarta
tijuana
veracruz
yucatan
nicaragua
panama
peru
montevideo
venezuela
virgin-islands
egypt
ethiopia
ghana
kenya
morocco
cape-town
durban
johannesburg
pretoria
tunisia