In [2]:
import requests
from bs4 import BeautifulSoup
import pandas as pd
url_to_scrape = 'http://data.vitalsigns.mtc.ca.gov/api/t5/flows/'
r = requests.get(url_to_scrape)
pd.DataFrame(r.json())
Out[2]:
2-person carpool
3-person carpool
4-person carpool
5-or-6-person carpool
7-or-more-person carpool
All Carpool
All Transit
Bicycle
Bus
Drove alone
...
Residence_Geo
Streetcar or trolley
Subway
Taxi
Total
Walked
Work_Geo_Short
Worked at home
Workplace_Geo
Year
0
33850
5400
1910
640
565
42365
31960
9770
20250
317945
...
Alameda County
255
10180
200
468180
23670
Alameda
5485
Workplayer_Geo
2010
1
0
0
0
0
0
0
20
0
20
10
...
Alameda County
0
0
0
30
0
Amador
0
Workplayer_Geo
2010
2
0
0
0
0
0
0
0
10
0
10
...
Alameda County
0
0
0
30
10
Butte
0
Workplayer_Geo
2010
3
0
0
0
0
0
0
0
0
0
15
...
Alameda County
0
0
0
15
0
Calaveras
0
Workplayer_Geo
2010
4
2870
545
195
80
50
3740
2380
240
520
32890
...
Alameda County
0
1770
0
39885
260
Contra Costa
325
Workplayer_Geo
2010
5
0
0
0
0
0
0
0
10
0
15
...
Alameda County
0
0
0
25
0
El Dorado
0
Workplayer_Geo
2010
6
0
0
0
0
0
0
0
0
0
125
...
Alameda County
0
0
0
125
0
Fresno
0
Workplayer_Geo
2010
7
0
0
0
0
0
0
0
0
0
15
...
Alameda County
0
0
0
15
0
Humboldt
0
Workplayer_Geo
2010
8
0
0
0
0
0
0
0
0
0
0
...
Alameda County
0
0
0
15
0
Imperial
15
Workplayer_Geo
2010
9
0
0
0
0
0
0
0
0
0
40
...
Alameda County
0
0
0
40
0
Kern
0
Workplayer_Geo
2010
10
10
0
0
0
0
10
0
0
0
0
...
Alameda County
0
0
0
10
0
Kings
0
Workplayer_Geo
2010
11
0
0
0
0
0
0
0
0
0
40
...
Alameda County
0
0
0
60
20
Lake
0
Workplayer_Geo
2010
12
0
0
0
0
0
0
0
0
0
15
...
Alameda County
0
0
0
15
0
Lassen
0
Workplayer_Geo
2010
13
40
0
0
0
0
40
15
40
15
460
...
Alameda County
0
0
0
690
25
Los Angeles
105
Workplayer_Geo
2010
14
0
0
0
0
0
0
0
0
0
60
...
Alameda County
0
0
0
60
0
Madera
0
Workplayer_Geo
2010
15
430
60
20
20
20
550
95
0
45
3015
...
Alameda County
0
40
0
3710
4
Marin
45
Workplayer_Geo
2010
16
0
0
0
0
0
0
0
0
0
4
...
Alameda County
0
0
0
4
0
Mariposa
0
Workplayer_Geo
2010
17
0
0
0
0
0
0
0
0
0
15
...
Alameda County
0
0
0
15
0
Mendocino
0
Workplayer_Geo
2010
18
40
10
0
0
0
50
0
0
0
90
...
Alameda County
0
0
0
140
0
Merced
0
Workplayer_Geo
2010
19
0
0
0
0
0
0
0
0
0
115
...
Alameda County
0
0
0
115
0
Monterey
0
Workplayer_Geo
2010
20
45
20
25
0
0
90
0
0
0
465
...
Alameda County
0
0
0
550
0
Napa
0
Workplayer_Geo
2010
21
0
0
0
0
0
0
0
0
0
60
...
Alameda County
0
0
0
60
0
Nevada
0
Workplayer_Geo
2010
22
4
30
0
0
0
34
30
0
30
135
...
Alameda County
0
0
0
240
4
Orange
35
Workplayer_Geo
2010
23
20
0
0
0
0
20
0
0
0
130
...
Alameda County
0
0
0
150
0
Placer
0
Workplayer_Geo
2010
24
0
0
0
0
0
0
0
0
0
65
...
Alameda County
0
0
0
90
25
Riverside
0
Workplayer_Geo
2010
25
35
0
0
0
55
90
105
0
60
820
...
Alameda County
0
20
0
1015
0
Sacramento
0
Workplayer_Geo
2010
26
20
0
0
0
0
20
0
0
0
70
...
Alameda County
0
0
0
120
0
San Benito
25
Workplayer_Geo
2010
27
60
0
0
0
0
60
0
0
0
150
...
Alameda County
0
0
0
235
15
San Bernardino
10
Workplayer_Geo
2010
28
15
0
0
0
0
15
10
0
0
185
...
Alameda County
0
10
0
285
40
San Diego
35
Workplayer_Geo
2010
29
3945
4720
325
60
115
9165
40285
160
7280
20565
...
Alameda County
575
27410
85
71860
345
San Francisco
990
Workplayer_Geo
2010
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
608
0
0
0
0
0
0
0
0
0
4
...
Tuolumne County
0
0
0
4
0
Contra Costa
0
Workplayer_Geo
2010
609
0
0
0
0
0
0
0
0
0
135
...
Tuolumne County
0
0
0
135
0
San Francisco
0
Workplayer_Geo
2010
610
0
0
0
0
0
0
0
0
0
60
...
Tuolumne County
0
0
0
60
0
San Mateo
0
Workplayer_Geo
2010
611
0
0
0
0
0
0
0
0
0
85
...
Tuolumne County
0
0
0
100
10
Santa Clara
0
Workplayer_Geo
2010
612
0
0
0
0
0
0
0
0
0
40
...
Tuolumne County
0
0
0
40
0
Solano
0
Workplayer_Geo
2010
613
10
4
0
0
0
14
0
0
0
30
...
Ventura County
0
0
0
60
0
Alameda
15
Workplayer_Geo
2010
614
0
0
0
0
0
0
0
0
0
15
...
Ventura County
0
0
0
15
0
Contra Costa
0
Workplayer_Geo
2010
615
0
0
0
0
0
0
0
0
0
0
...
Ventura County
0
0
0
10
10
Marin
0
Workplayer_Geo
2010
616
0
0
0
0
0
0
0
0
0
15
...
Ventura County
0
0
0
15
0
Napa
0
Workplayer_Geo
2010
617
10
0
0
0
0
10
0
0
0
10
...
Ventura County
0
0
0
80
0
San Francisco
65
Workplayer_Geo
2010
618
15
15
0
0
0
30
0
0
0
165
...
Ventura County
0
0
0
205
0
San Mateo
10
Workplayer_Geo
2010
619
15
0
0
0
0
15
0
0
0
220
...
Ventura County
0
0
0
255
0
Santa Clara
20
Workplayer_Geo
2010
620
10
0
0
0
0
10
0
0
0
25
...
Ventura County
0
0
0
35
0
Sonoma
0
Workplayer_Geo
2010
621
45
0
0
0
0
45
85
0
10
450
...
Yolo County
0
0
0
595
15
Alameda
0
Workplayer_Geo
2010
622
60
40
0
0
0
100
15
25
0
530
...
Yolo County
0
0
0
665
0
Contra Costa
0
Workplayer_Geo
2010
623
20
0
0
0
0
20
0
0
0
100
...
Yolo County
0
0
0
120
0
Marin
0
Workplayer_Geo
2010
624
15
0
0
0
0
15
0
0
0
160
...
Yolo County
0
0
0
170
0
Napa
0
Workplayer_Geo
2010
625
100
0
0
0
50
150
85
0
10
240
...
Yolo County
0
0
0
470
0
San Francisco
0
Workplayer_Geo
2010
626
0
0
0
0
0
0
0
0
0
160
...
Yolo County
0
0
0
160
0
San Mateo
0
Workplayer_Geo
2010
627
0
0
0
0
0
0
0
0
0
255
...
Yolo County
0
0
0
265
0
Santa Clara
0
Workplayer_Geo
2010
628
520
180
15
0
15
730
40
10
25
4230
...
Yolo County
0
0
0
5045
25
Solano
0
Workplayer_Geo
2010
629
40
0
0
0
0
40
0
0
0
120
...
Yolo County
0
0
0
160
0
Sonoma
0
Workplayer_Geo
2010
630
25
10
0
0
0
35
0
0
0
40
...
Yuba County
0
0
0
75
0
Alameda
0
Workplayer_Geo
2010
631
0
10
0
0
0
10
0
0
0
10
...
Yuba County
0
0
0
15
0
Contra Costa
0
Workplayer_Geo
2010
632
10
0
35
0
0
45
0
0
0
10
...
Yuba County
0
0
0
55
0
Napa
0
Workplayer_Geo
2010
633
25
0
0
0
0
25
20
0
0
25
...
Yuba County
20
0
0
70
0
San Francisco
0
Workplayer_Geo
2010
634
0
0
0
0
0
0
0
0
0
15
...
Yuba County
0
0
0
15
0
San Mateo
0
Workplayer_Geo
2010
635
0
10
0
0
0
10
0
0
0
35
...
Yuba County
0
0
0
40
0
Santa Clara
0
Workplayer_Geo
2010
636
25
0
0
0
0
25
0
0
0
80
...
Yuba County
0
0
0
105
0
Solano
0
Workplayer_Geo
2010
637
0
0
0
0
0
0
0
0
0
85
...
Yuba County
0
0
0
85
0
Sonoma
0
Workplayer_Geo
2010
638 rows × 24 columns
In [ ]:
Content source: vta/Data-Gathering
Similar notebooks: