ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
813 rows where fips = 6067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281001 | 281001 | 2020-06-28 | Sacramento | California | 6067 | 2775 | 66 |
277854 | 277854 | 2020-06-27 | Sacramento | California | 6067 | 2686 | 66 |
274706 | 274706 | 2020-06-26 | Sacramento | California | 6067 | 2665 | 66 |
271566 | 271566 | 2020-06-25 | Sacramento | California | 6067 | 2511 | 66 |
268431 | 268431 | 2020-06-24 | Sacramento | California | 6067 | 2439 | 66 |
265301 | 265301 | 2020-06-23 | Sacramento | California | 6067 | 2373 | 66 |
262173 | 262173 | 2020-06-22 | Sacramento | California | 6067 | 2242 | 67 |
259046 | 259046 | 2020-06-21 | Sacramento | California | 6067 | 2159 | 67 |
255919 | 255919 | 2020-06-20 | Sacramento | California | 6067 | 2068 | 67 |
252800 | 252800 | 2020-06-19 | Sacramento | California | 6067 | 1975 | 67 |
249685 | 249685 | 2020-06-18 | Sacramento | California | 6067 | 1939 | 67 |
246573 | 246573 | 2020-06-17 | Sacramento | California | 6067 | 1891 | 67 |
243460 | 243460 | 2020-06-16 | Sacramento | California | 6067 | 1824 | 63 |
240349 | 240349 | 2020-06-15 | Sacramento | California | 6067 | 1793 | 63 |
237241 | 237241 | 2020-06-14 | Sacramento | California | 6067 | 1752 | 63 |
234134 | 234134 | 2020-06-13 | Sacramento | California | 6067 | 1715 | 63 |
231028 | 231028 | 2020-06-12 | Sacramento | California | 6067 | 1703 | 63 |
227925 | 227925 | 2020-06-11 | Sacramento | California | 6067 | 1669 | 63 |
224823 | 224823 | 2020-06-10 | Sacramento | California | 6067 | 1641 | 62 |
221728 | 221728 | 2020-06-09 | Sacramento | California | 6067 | 1623 | 61 |
218633 | 218633 | 2020-06-08 | Sacramento | California | 6067 | 1587 | 61 |
215542 | 215542 | 2020-06-07 | Sacramento | California | 6067 | 1568 | 59 |
212455 | 212455 | 2020-06-06 | Sacramento | California | 6067 | 1536 | 59 |
209370 | 209370 | 2020-06-05 | Sacramento | California | 6067 | 1518 | 59 |
206289 | 206289 | 2020-06-04 | Sacramento | California | 6067 | 1489 | 58 |
203209 | 203209 | 2020-06-03 | Sacramento | California | 6067 | 1462 | 58 |
200133 | 200133 | 2020-06-02 | Sacramento | California | 6067 | 1438 | 58 |
197060 | 197060 | 2020-06-01 | Sacramento | California | 6067 | 1428 | 58 |
193990 | 193990 | 2020-05-31 | Sacramento | California | 6067 | 1414 | 57 |
190923 | 190923 | 2020-05-30 | Sacramento | California | 6067 | 1399 | 57 |
187858 | 187858 | 2020-05-29 | Sacramento | California | 6067 | 1372 | 57 |
184802 | 184802 | 2020-05-28 | Sacramento | California | 6067 | 1348 | 57 |
181748 | 181748 | 2020-05-27 | Sacramento | California | 6067 | 1318 | 57 |
178704 | 178704 | 2020-05-26 | Sacramento | California | 6067 | 1309 | 57 |
175660 | 175660 | 2020-05-25 | Sacramento | California | 6067 | 1301 | 57 |
172616 | 172616 | 2020-05-24 | Sacramento | California | 6067 | 1292 | 57 |
169575 | 169575 | 2020-05-23 | Sacramento | California | 6067 | 1288 | 57 |
166538 | 166538 | 2020-05-22 | Sacramento | California | 6067 | 1271 | 57 |
163506 | 163506 | 2020-05-21 | Sacramento | California | 6067 | 1265 | 57 |
160478 | 160478 | 2020-05-20 | Sacramento | California | 6067 | 1254 | 57 |
157452 | 157452 | 2020-05-19 | Sacramento | California | 6067 | 1249 | 56 |
154436 | 154436 | 2020-05-18 | Sacramento | California | 6067 | 1244 | 56 |
151424 | 151424 | 2020-05-17 | Sacramento | California | 6067 | 1236 | 55 |
148415 | 148415 | 2020-05-16 | Sacramento | California | 6067 | 1221 | 55 |
145411 | 145411 | 2020-05-15 | Sacramento | California | 6067 | 1210 | 54 |
142412 | 142412 | 2020-05-14 | Sacramento | California | 6067 | 1193 | 54 |
139416 | 139416 | 2020-05-13 | Sacramento | California | 6067 | 1182 | 52 |
136425 | 136425 | 2020-05-12 | Sacramento | California | 6067 | 1180 | 52 |
133435 | 133435 | 2020-05-11 | Sacramento | California | 6067 | 1172 | 52 |
130445 | 130445 | 2020-05-10 | Sacramento | California | 6067 | 1166 | 52 |
127455 | 127455 | 2020-05-09 | Sacramento | California | 6067 | 1164 | 51 |
124470 | 124470 | 2020-05-08 | Sacramento | California | 6067 | 1159 | 50 |
121490 | 121490 | 2020-05-07 | Sacramento | California | 6067 | 1132 | 49 |
118523 | 118523 | 2020-05-06 | Sacramento | California | 6067 | 1132 | 47 |
115564 | 115564 | 2020-05-05 | Sacramento | California | 6067 | 1132 | 47 |
112681 | 112681 | 2020-05-04 | Sacramento | California | 6067 | 1126 | 47 |
109806 | 109806 | 2020-05-03 | Sacramento | California | 6067 | 1116 | 43 |
106937 | 106937 | 2020-05-02 | Sacramento | California | 6067 | 1106 | 43 |
104072 | 104072 | 2020-05-01 | Sacramento | California | 6067 | 1090 | 43 |
101217 | 101217 | 2020-04-30 | Sacramento | California | 6067 | 1077 | 43 |
98367 | 98367 | 2020-04-29 | Sacramento | California | 6067 | 1068 | 42 |
95522 | 95522 | 2020-04-28 | Sacramento | California | 6067 | 1053 | 41 |
92690 | 92690 | 2020-04-27 | Sacramento | California | 6067 | 1045 | 41 |
89872 | 89872 | 2020-04-26 | Sacramento | California | 6067 | 1037 | 41 |
87055 | 87055 | 2020-04-25 | Sacramento | California | 6067 | 1025 | 41 |
84247 | 84247 | 2020-04-24 | Sacramento | California | 6067 | 1019 | 41 |
81447 | 81447 | 2020-04-23 | Sacramento | California | 6067 | 987 | 41 |
78653 | 78653 | 2020-04-22 | Sacramento | California | 6067 | 971 | 36 |
75869 | 75869 | 2020-04-21 | Sacramento | California | 6067 | 954 | 35 |
73093 | 73093 | 2020-04-20 | Sacramento | California | 6067 | 940 | 34 |
70324 | 70324 | 2020-04-19 | Sacramento | California | 6067 | 925 | 34 |
67562 | 67562 | 2020-04-18 | Sacramento | California | 6067 | 914 | 33 |
64814 | 64814 | 2020-04-17 | Sacramento | California | 6067 | 896 | 32 |
62081 | 62081 | 2020-04-16 | Sacramento | California | 6067 | 879 | 32 |
59362 | 59362 | 2020-04-15 | Sacramento | California | 6067 | 853 | 32 |
56654 | 56654 | 2020-04-14 | Sacramento | California | 6067 | 816 | 28 |
53962 | 53962 | 2020-04-13 | Sacramento | California | 6067 | 739 | 27 |
51283 | 51283 | 2020-04-12 | Sacramento | California | 6067 | 707 | 26 |
48621 | 48621 | 2020-04-11 | Sacramento | California | 6067 | 699 | 26 |
45991 | 45991 | 2020-04-10 | Sacramento | California | 6067 | 652 | 24 |
43391 | 43391 | 2020-04-09 | Sacramento | California | 6067 | 612 | 22 |
40819 | 40819 | 2020-04-08 | Sacramento | California | 6067 | 579 | 22 |
38275 | 38275 | 2020-04-07 | Sacramento | California | 6067 | 524 | 21 |
35786 | 35786 | 2020-04-06 | Sacramento | California | 6067 | 461 | 18 |
33341 | 33341 | 2020-04-05 | Sacramento | California | 6067 | 441 | 16 |
30935 | 30935 | 2020-04-04 | Sacramento | California | 6067 | 411 | 12 |
28577 | 28577 | 2020-04-03 | Sacramento | California | 6067 | 389 | 10 |
26278 | 26278 | 2020-04-02 | Sacramento | California | 6067 | 340 | 9 |
24049 | 24049 | 2020-04-01 | Sacramento | California | 6067 | 314 | 9 |
21891 | 21891 | 2020-03-31 | Sacramento | California | 6067 | 224 | 7 |
19816 | 19816 | 2020-03-30 | Sacramento | California | 6067 | 224 | 7 |
17839 | 17839 | 2020-03-29 | Sacramento | California | 6067 | 164 | 6 |
15950 | 15950 | 2020-03-28 | Sacramento | California | 6067 | 164 | 6 |
14168 | 14168 | 2020-03-27 | Sacramento | California | 6067 | 164 | 6 |
12502 | 12502 | 2020-03-26 | Sacramento | California | 6067 | 112 | 5 |
10957 | 10957 | 2020-03-25 | Sacramento | California | 6067 | 112 | 5 |
9585 | 9585 | 2020-03-24 | Sacramento | California | 6067 | 87 | 4 |
8342 | 8342 | 2020-03-23 | Sacramento | California | 6067 | 87 | 4 |
7199 | 7199 | 2020-03-22 | Sacramento | California | 6067 | 52 | 3 |
6165 | 6165 | 2020-03-21 | Sacramento | California | 6067 | 52 | 3 |
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);