ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 6093 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
6177 | 6177 | 2020-03-21 | Siskiyou | California | 6093 | 2 | 0 |
7211 | 7211 | 2020-03-22 | Siskiyou | California | 6093 | 2 | 0 |
8354 | 8354 | 2020-03-23 | Siskiyou | California | 6093 | 3 | 0 |
9597 | 9597 | 2020-03-24 | Siskiyou | California | 6093 | 3 | 0 |
10969 | 10969 | 2020-03-25 | Siskiyou | California | 6093 | 3 | 0 |
12514 | 12514 | 2020-03-26 | Siskiyou | California | 6093 | 3 | 0 |
14180 | 14180 | 2020-03-27 | Siskiyou | California | 6093 | 3 | 0 |
15962 | 15962 | 2020-03-28 | Siskiyou | California | 6093 | 3 | 0 |
17851 | 17851 | 2020-03-29 | Siskiyou | California | 6093 | 3 | 0 |
19828 | 19828 | 2020-03-30 | Siskiyou | California | 6093 | 3 | 0 |
21903 | 21903 | 2020-03-31 | Siskiyou | California | 6093 | 3 | 0 |
24061 | 24061 | 2020-04-01 | Siskiyou | California | 6093 | 3 | 0 |
26290 | 26290 | 2020-04-02 | Siskiyou | California | 6093 | 3 | 0 |
28589 | 28589 | 2020-04-03 | Siskiyou | California | 6093 | 3 | 0 |
30947 | 30947 | 2020-04-04 | Siskiyou | California | 6093 | 3 | 0 |
33353 | 33353 | 2020-04-05 | Siskiyou | California | 6093 | 3 | 0 |
35798 | 35798 | 2020-04-06 | Siskiyou | California | 6093 | 4 | 0 |
38287 | 38287 | 2020-04-07 | Siskiyou | California | 6093 | 4 | 0 |
40831 | 40831 | 2020-04-08 | Siskiyou | California | 6093 | 4 | 0 |
43403 | 43403 | 2020-04-09 | Siskiyou | California | 6093 | 4 | 0 |
46003 | 46003 | 2020-04-10 | Siskiyou | California | 6093 | 5 | 0 |
48633 | 48633 | 2020-04-11 | Siskiyou | California | 6093 | 5 | 0 |
51295 | 51295 | 2020-04-12 | Siskiyou | California | 6093 | 5 | 0 |
53974 | 53974 | 2020-04-13 | Siskiyou | California | 6093 | 5 | 0 |
56666 | 56666 | 2020-04-14 | Siskiyou | California | 6093 | 5 | 0 |
59374 | 59374 | 2020-04-15 | Siskiyou | California | 6093 | 5 | 0 |
62093 | 62093 | 2020-04-16 | Siskiyou | California | 6093 | 5 | 0 |
64826 | 64826 | 2020-04-17 | Siskiyou | California | 6093 | 5 | 0 |
67574 | 67574 | 2020-04-18 | Siskiyou | California | 6093 | 5 | 0 |
70336 | 70336 | 2020-04-19 | Siskiyou | California | 6093 | 5 | 0 |
73105 | 73105 | 2020-04-20 | Siskiyou | California | 6093 | 5 | 0 |
75881 | 75881 | 2020-04-21 | Siskiyou | California | 6093 | 5 | 0 |
78665 | 78665 | 2020-04-22 | Siskiyou | California | 6093 | 5 | 0 |
81459 | 81459 | 2020-04-23 | Siskiyou | California | 6093 | 5 | 0 |
84259 | 84259 | 2020-04-24 | Siskiyou | California | 6093 | 5 | 0 |
87067 | 87067 | 2020-04-25 | Siskiyou | California | 6093 | 5 | 0 |
89884 | 89884 | 2020-04-26 | Siskiyou | California | 6093 | 5 | 0 |
92702 | 92702 | 2020-04-27 | Siskiyou | California | 6093 | 5 | 0 |
95534 | 95534 | 2020-04-28 | Siskiyou | California | 6093 | 5 | 0 |
98379 | 98379 | 2020-04-29 | Siskiyou | California | 6093 | 5 | 0 |
101229 | 101229 | 2020-04-30 | Siskiyou | California | 6093 | 5 | 0 |
104084 | 104084 | 2020-05-01 | Siskiyou | California | 6093 | 5 | 0 |
106949 | 106949 | 2020-05-02 | Siskiyou | California | 6093 | 5 | 0 |
109818 | 109818 | 2020-05-03 | Siskiyou | California | 6093 | 5 | 0 |
112693 | 112693 | 2020-05-04 | Siskiyou | California | 6093 | 5 | 0 |
115576 | 115576 | 2020-05-05 | Siskiyou | California | 6093 | 5 | 0 |
118535 | 118535 | 2020-05-06 | Siskiyou | California | 6093 | 5 | 0 |
121502 | 121502 | 2020-05-07 | Siskiyou | California | 6093 | 5 | 0 |
124482 | 124482 | 2020-05-08 | Siskiyou | California | 6093 | 5 | 0 |
127467 | 127467 | 2020-05-09 | Siskiyou | California | 6093 | 5 | 0 |
130457 | 130457 | 2020-05-10 | Siskiyou | California | 6093 | 5 | 0 |
133447 | 133447 | 2020-05-11 | Siskiyou | California | 6093 | 5 | 0 |
136437 | 136437 | 2020-05-12 | Siskiyou | California | 6093 | 5 | 0 |
139428 | 139428 | 2020-05-13 | Siskiyou | California | 6093 | 5 | 0 |
142424 | 142424 | 2020-05-14 | Siskiyou | California | 6093 | 5 | 0 |
145423 | 145423 | 2020-05-15 | Siskiyou | California | 6093 | 5 | 0 |
148427 | 148427 | 2020-05-16 | Siskiyou | California | 6093 | 5 | 0 |
151436 | 151436 | 2020-05-17 | Siskiyou | California | 6093 | 6 | 0 |
154448 | 154448 | 2020-05-18 | Siskiyou | California | 6093 | 6 | 0 |
157464 | 157464 | 2020-05-19 | Siskiyou | California | 6093 | 6 | 0 |
160490 | 160490 | 2020-05-20 | Siskiyou | California | 6093 | 6 | 0 |
163518 | 163518 | 2020-05-21 | Siskiyou | California | 6093 | 6 | 0 |
166551 | 166551 | 2020-05-22 | Siskiyou | California | 6093 | 6 | 0 |
169588 | 169588 | 2020-05-23 | Siskiyou | California | 6093 | 6 | 0 |
172629 | 172629 | 2020-05-24 | Siskiyou | California | 6093 | 6 | 0 |
175673 | 175673 | 2020-05-25 | Siskiyou | California | 6093 | 6 | 0 |
178717 | 178717 | 2020-05-26 | Siskiyou | California | 6093 | 6 | 0 |
181761 | 181761 | 2020-05-27 | Siskiyou | California | 6093 | 6 | 0 |
184815 | 184815 | 2020-05-28 | Siskiyou | California | 6093 | 6 | 0 |
187871 | 187871 | 2020-05-29 | Siskiyou | California | 6093 | 7 | 0 |
190936 | 190936 | 2020-05-30 | Siskiyou | California | 6093 | 7 | 0 |
194003 | 194003 | 2020-05-31 | Siskiyou | California | 6093 | 7 | 0 |
197073 | 197073 | 2020-06-01 | Siskiyou | California | 6093 | 7 | 0 |
200146 | 200146 | 2020-06-02 | Siskiyou | California | 6093 | 7 | 0 |
203222 | 203222 | 2020-06-03 | Siskiyou | California | 6093 | 8 | 0 |
206302 | 206302 | 2020-06-04 | Siskiyou | California | 6093 | 9 | 0 |
209383 | 209383 | 2020-06-05 | Siskiyou | California | 6093 | 9 | 0 |
212468 | 212468 | 2020-06-06 | Siskiyou | California | 6093 | 9 | 0 |
215555 | 215555 | 2020-06-07 | Siskiyou | California | 6093 | 9 | 0 |
218646 | 218646 | 2020-06-08 | Siskiyou | California | 6093 | 12 | 0 |
221741 | 221741 | 2020-06-09 | Siskiyou | California | 6093 | 14 | 0 |
224836 | 224836 | 2020-06-10 | Siskiyou | California | 6093 | 14 | 0 |
227938 | 227938 | 2020-06-11 | Siskiyou | California | 6093 | 14 | 0 |
231041 | 231041 | 2020-06-12 | Siskiyou | California | 6093 | 15 | 0 |
234147 | 234147 | 2020-06-13 | Siskiyou | California | 6093 | 15 | 0 |
237254 | 237254 | 2020-06-14 | Siskiyou | California | 6093 | 16 | 0 |
240362 | 240362 | 2020-06-15 | Siskiyou | California | 6093 | 18 | 0 |
243473 | 243473 | 2020-06-16 | Siskiyou | California | 6093 | 20 | 0 |
246586 | 246586 | 2020-06-17 | Siskiyou | California | 6093 | 20 | 0 |
249698 | 249698 | 2020-06-18 | Siskiyou | California | 6093 | 21 | 0 |
252813 | 252813 | 2020-06-19 | Siskiyou | California | 6093 | 21 | 0 |
255932 | 255932 | 2020-06-20 | Siskiyou | California | 6093 | 21 | 0 |
259059 | 259059 | 2020-06-21 | Siskiyou | California | 6093 | 23 | 0 |
262186 | 262186 | 2020-06-22 | Siskiyou | California | 6093 | 24 | 0 |
265314 | 265314 | 2020-06-23 | Siskiyou | California | 6093 | 24 | 0 |
268444 | 268444 | 2020-06-24 | Siskiyou | California | 6093 | 26 | 0 |
271579 | 271579 | 2020-06-25 | Siskiyou | California | 6093 | 26 | 0 |
274719 | 274719 | 2020-06-26 | Siskiyou | California | 6093 | 26 | 0 |
277867 | 277867 | 2020-06-27 | Siskiyou | California | 6093 | 27 | 0 |
281014 | 281014 | 2020-06-28 | Siskiyou | California | 6093 | 27 | 0 |
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);