ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "San Joaquin" and state = "California" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- …
state 1
- California · 795 ✖
fips 1
- 6077 795
county 1
- San Joaquin · 795 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1013 | 1013 | 2020-03-10 | San Joaquin | California | 6077 | 1 | 0 |
1179 | 1179 | 2020-03-11 | San Joaquin | California | 6077 | 1 | 0 |
1385 | 1385 | 2020-03-12 | San Joaquin | California | 6077 | 3 | 0 |
1646 | 1646 | 2020-03-13 | San Joaquin | California | 6077 | 8 | 0 |
1963 | 1963 | 2020-03-14 | San Joaquin | California | 6077 | 8 | 0 |
2343 | 2343 | 2020-03-15 | San Joaquin | California | 6077 | 8 | 0 |
2778 | 2778 | 2020-03-16 | San Joaquin | California | 6077 | 9 | 0 |
3260 | 3260 | 2020-03-17 | San Joaquin | California | 6077 | 13 | 0 |
3814 | 3814 | 2020-03-18 | San Joaquin | California | 6077 | 14 | 2 |
4474 | 4474 | 2020-03-19 | San Joaquin | California | 6077 | 17 | 2 |
5249 | 5249 | 2020-03-20 | San Joaquin | California | 6077 | 25 | 2 |
6170 | 6170 | 2020-03-21 | San Joaquin | California | 6077 | 31 | 2 |
7204 | 7204 | 2020-03-22 | San Joaquin | California | 6077 | 41 | 2 |
8347 | 8347 | 2020-03-23 | San Joaquin | California | 6077 | 51 | 2 |
9590 | 9590 | 2020-03-24 | San Joaquin | California | 6077 | 60 | 2 |
10962 | 10962 | 2020-03-25 | San Joaquin | California | 6077 | 71 | 3 |
12507 | 12507 | 2020-03-26 | San Joaquin | California | 6077 | 83 | 3 |
14173 | 14173 | 2020-03-27 | San Joaquin | California | 6077 | 93 | 4 |
15955 | 15955 | 2020-03-28 | San Joaquin | California | 6077 | 108 | 4 |
17844 | 17844 | 2020-03-29 | San Joaquin | California | 6077 | 121 | 5 |
19821 | 19821 | 2020-03-30 | San Joaquin | California | 6077 | 136 | 6 |
21896 | 21896 | 2020-03-31 | San Joaquin | California | 6077 | 151 | 8 |
24054 | 24054 | 2020-04-01 | San Joaquin | California | 6077 | 161 | 8 |
26283 | 26283 | 2020-04-02 | San Joaquin | California | 6077 | 178 | 10 |
28582 | 28582 | 2020-04-03 | San Joaquin | California | 6077 | 185 | 11 |
30940 | 30940 | 2020-04-04 | San Joaquin | California | 6077 | 191 | 11 |
33346 | 33346 | 2020-04-05 | San Joaquin | California | 6077 | 203 | 11 |
35791 | 35791 | 2020-04-06 | San Joaquin | California | 6077 | 212 | 11 |
38280 | 38280 | 2020-04-07 | San Joaquin | California | 6077 | 223 | 13 |
40824 | 40824 | 2020-04-08 | San Joaquin | California | 6077 | 237 | 14 |
43396 | 43396 | 2020-04-09 | San Joaquin | California | 6077 | 245 | 14 |
45996 | 45996 | 2020-04-10 | San Joaquin | California | 6077 | 257 | 14 |
48626 | 48626 | 2020-04-11 | San Joaquin | California | 6077 | 260 | 15 |
51288 | 51288 | 2020-04-12 | San Joaquin | California | 6077 | 273 | 16 |
53967 | 53967 | 2020-04-13 | San Joaquin | California | 6077 | 309 | 17 |
56659 | 56659 | 2020-04-14 | San Joaquin | California | 6077 | 335 | 17 |
59367 | 59367 | 2020-04-15 | San Joaquin | California | 6077 | 364 | 17 |
62086 | 62086 | 2020-04-16 | San Joaquin | California | 6077 | 369 | 17 |
64819 | 64819 | 2020-04-17 | San Joaquin | California | 6077 | 398 | 17 |
67567 | 67567 | 2020-04-18 | San Joaquin | California | 6077 | 410 | 17 |
70329 | 70329 | 2020-04-19 | San Joaquin | California | 6077 | 418 | 17 |
73098 | 73098 | 2020-04-20 | San Joaquin | California | 6077 | 446 | 18 |
75874 | 75874 | 2020-04-21 | San Joaquin | California | 6077 | 456 | 20 |
78658 | 78658 | 2020-04-22 | San Joaquin | California | 6077 | 472 | 20 |
81452 | 81452 | 2020-04-23 | San Joaquin | California | 6077 | 487 | 22 |
84252 | 84252 | 2020-04-24 | San Joaquin | California | 6077 | 495 | 24 |
87060 | 87060 | 2020-04-25 | San Joaquin | California | 6077 | 507 | 25 |
89877 | 89877 | 2020-04-26 | San Joaquin | California | 6077 | 523 | 25 |
92695 | 92695 | 2020-04-27 | San Joaquin | California | 6077 | 527 | 25 |
95527 | 95527 | 2020-04-28 | San Joaquin | California | 6077 | 529 | 25 |
98372 | 98372 | 2020-04-29 | San Joaquin | California | 6077 | 540 | 25 |
101222 | 101222 | 2020-04-30 | San Joaquin | California | 6077 | 543 | 25 |
104077 | 104077 | 2020-05-01 | San Joaquin | California | 6077 | 557 | 25 |
106942 | 106942 | 2020-05-02 | San Joaquin | California | 6077 | 560 | 25 |
109811 | 109811 | 2020-05-03 | San Joaquin | California | 6077 | 570 | 25 |
112686 | 112686 | 2020-05-04 | San Joaquin | California | 6077 | 574 | 26 |
115569 | 115569 | 2020-05-05 | San Joaquin | California | 6077 | 578 | 26 |
118528 | 118528 | 2020-05-06 | San Joaquin | California | 6077 | 579 | 27 |
121495 | 121495 | 2020-05-07 | San Joaquin | California | 6077 | 581 | 28 |
124475 | 124475 | 2020-05-08 | San Joaquin | California | 6077 | 597 | 28 |
127460 | 127460 | 2020-05-09 | San Joaquin | California | 6077 | 605 | 28 |
130450 | 130450 | 2020-05-10 | San Joaquin | California | 6077 | 612 | 29 |
133440 | 133440 | 2020-05-11 | San Joaquin | California | 6077 | 621 | 29 |
136430 | 136430 | 2020-05-12 | San Joaquin | California | 6077 | 629 | 30 |
139421 | 139421 | 2020-05-13 | San Joaquin | California | 6077 | 638 | 31 |
142417 | 142417 | 2020-05-14 | San Joaquin | California | 6077 | 644 | 31 |
145416 | 145416 | 2020-05-15 | San Joaquin | California | 6077 | 659 | 31 |
148420 | 148420 | 2020-05-16 | San Joaquin | California | 6077 | 670 | 31 |
151429 | 151429 | 2020-05-17 | San Joaquin | California | 6077 | 689 | 32 |
154441 | 154441 | 2020-05-18 | San Joaquin | California | 6077 | 699 | 32 |
157457 | 157457 | 2020-05-19 | San Joaquin | California | 6077 | 709 | 33 |
160483 | 160483 | 2020-05-20 | San Joaquin | California | 6077 | 716 | 33 |
163511 | 163511 | 2020-05-21 | San Joaquin | California | 6077 | 733 | 33 |
166543 | 166543 | 2020-05-22 | San Joaquin | California | 6077 | 752 | 33 |
169580 | 169580 | 2020-05-23 | San Joaquin | California | 6077 | 752 | 33 |
172621 | 172621 | 2020-05-24 | San Joaquin | California | 6077 | 759 | 33 |
175665 | 175665 | 2020-05-25 | San Joaquin | California | 6077 | 760 | 33 |
178709 | 178709 | 2020-05-26 | San Joaquin | California | 6077 | 771 | 33 |
181753 | 181753 | 2020-05-27 | San Joaquin | California | 6077 | 834 | 34 |
184807 | 184807 | 2020-05-28 | San Joaquin | California | 6077 | 842 | 35 |
187863 | 187863 | 2020-05-29 | San Joaquin | California | 6077 | 858 | 35 |
190928 | 190928 | 2020-05-30 | San Joaquin | California | 6077 | 858 | 35 |
193995 | 193995 | 2020-05-31 | San Joaquin | California | 6077 | 888 | 35 |
197065 | 197065 | 2020-06-01 | San Joaquin | California | 6077 | 908 | 35 |
200138 | 200138 | 2020-06-02 | San Joaquin | California | 6077 | 982 | 35 |
203214 | 203214 | 2020-06-03 | San Joaquin | California | 6077 | 1080 | 35 |
206294 | 206294 | 2020-06-04 | San Joaquin | California | 6077 | 1024 | 36 |
209375 | 209375 | 2020-06-05 | San Joaquin | California | 6077 | 1050 | 36 |
212460 | 212460 | 2020-06-06 | San Joaquin | California | 6077 | 1118 | 37 |
215547 | 215547 | 2020-06-07 | San Joaquin | California | 6077 | 1161 | 37 |
218638 | 218638 | 2020-06-08 | San Joaquin | California | 6077 | 1244 | 37 |
221733 | 221733 | 2020-06-09 | San Joaquin | California | 6077 | 1308 | 39 |
224828 | 224828 | 2020-06-10 | San Joaquin | California | 6077 | 1358 | 40 |
227930 | 227930 | 2020-06-11 | San Joaquin | California | 6077 | 1437 | 42 |
231033 | 231033 | 2020-06-12 | San Joaquin | California | 6077 | 1493 | 42 |
234139 | 234139 | 2020-06-13 | San Joaquin | California | 6077 | 1547 | 43 |
237246 | 237246 | 2020-06-14 | San Joaquin | California | 6077 | 1652 | 43 |
240354 | 240354 | 2020-06-15 | San Joaquin | California | 6077 | 1716 | 43 |
243465 | 243465 | 2020-06-16 | San Joaquin | California | 6077 | 1749 | 47 |
246578 | 246578 | 2020-06-17 | San Joaquin | California | 6077 | 1888 | 47 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);