ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Nevada" and state = "California" 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 |
---|---|---|---|---|---|---|---|
2769 | 2769 | 2020-03-16 | Nevada | California | 6057 | 1 | 0 |
3251 | 3251 | 2020-03-17 | Nevada | California | 6057 | 1 | 0 |
3805 | 3805 | 2020-03-18 | Nevada | California | 6057 | 1 | 0 |
4465 | 4465 | 2020-03-19 | Nevada | California | 6057 | 1 | 0 |
5240 | 5240 | 2020-03-20 | Nevada | California | 6057 | 1 | 0 |
6161 | 6161 | 2020-03-21 | Nevada | California | 6057 | 1 | 0 |
7195 | 7195 | 2020-03-22 | Nevada | California | 6057 | 1 | 0 |
8338 | 8338 | 2020-03-23 | Nevada | California | 6057 | 3 | 0 |
9581 | 9581 | 2020-03-24 | Nevada | California | 6057 | 4 | 0 |
10953 | 10953 | 2020-03-25 | Nevada | California | 6057 | 4 | 0 |
12498 | 12498 | 2020-03-26 | Nevada | California | 6057 | 8 | 0 |
14164 | 14164 | 2020-03-27 | Nevada | California | 6057 | 12 | 0 |
15946 | 15946 | 2020-03-28 | Nevada | California | 6057 | 12 | 0 |
17835 | 17835 | 2020-03-29 | Nevada | California | 6057 | 12 | 0 |
19812 | 19812 | 2020-03-30 | Nevada | California | 6057 | 18 | 0 |
21886 | 21886 | 2020-03-31 | Nevada | California | 6057 | 21 | 0 |
24044 | 24044 | 2020-04-01 | Nevada | California | 6057 | 26 | 0 |
26273 | 26273 | 2020-04-02 | Nevada | California | 6057 | 30 | 0 |
28572 | 28572 | 2020-04-03 | Nevada | California | 6057 | 31 | 1 |
30930 | 30930 | 2020-04-04 | Nevada | California | 6057 | 31 | 1 |
33336 | 33336 | 2020-04-05 | Nevada | California | 6057 | 31 | 1 |
35781 | 35781 | 2020-04-06 | Nevada | California | 6057 | 32 | 1 |
38270 | 38270 | 2020-04-07 | Nevada | California | 6057 | 34 | 1 |
40814 | 40814 | 2020-04-08 | Nevada | California | 6057 | 34 | 1 |
43386 | 43386 | 2020-04-09 | Nevada | California | 6057 | 34 | 1 |
45986 | 45986 | 2020-04-10 | Nevada | California | 6057 | 34 | 1 |
48616 | 48616 | 2020-04-11 | Nevada | California | 6057 | 34 | 1 |
51278 | 51278 | 2020-04-12 | Nevada | California | 6057 | 34 | 1 |
53957 | 53957 | 2020-04-13 | Nevada | California | 6057 | 34 | 1 |
56649 | 56649 | 2020-04-14 | Nevada | California | 6057 | 34 | 1 |
59357 | 59357 | 2020-04-15 | Nevada | California | 6057 | 34 | 1 |
62076 | 62076 | 2020-04-16 | Nevada | California | 6057 | 34 | 1 |
64809 | 64809 | 2020-04-17 | Nevada | California | 6057 | 36 | 1 |
67557 | 67557 | 2020-04-18 | Nevada | California | 6057 | 36 | 1 |
70319 | 70319 | 2020-04-19 | Nevada | California | 6057 | 36 | 1 |
73088 | 73088 | 2020-04-20 | Nevada | California | 6057 | 38 | 1 |
75864 | 75864 | 2020-04-21 | Nevada | California | 6057 | 38 | 1 |
78648 | 78648 | 2020-04-22 | Nevada | California | 6057 | 36 | 1 |
81442 | 81442 | 2020-04-23 | Nevada | California | 6057 | 36 | 1 |
84242 | 84242 | 2020-04-24 | Nevada | California | 6057 | 37 | 1 |
87050 | 87050 | 2020-04-25 | Nevada | California | 6057 | 37 | 1 |
89867 | 89867 | 2020-04-26 | Nevada | California | 6057 | 37 | 1 |
92685 | 92685 | 2020-04-27 | Nevada | California | 6057 | 39 | 1 |
95517 | 95517 | 2020-04-28 | Nevada | California | 6057 | 41 | 1 |
98362 | 98362 | 2020-04-29 | Nevada | California | 6057 | 41 | 1 |
101212 | 101212 | 2020-04-30 | Nevada | California | 6057 | 41 | 1 |
104067 | 104067 | 2020-05-01 | Nevada | California | 6057 | 41 | 1 |
106932 | 106932 | 2020-05-02 | Nevada | California | 6057 | 41 | 1 |
109801 | 109801 | 2020-05-03 | Nevada | California | 6057 | 41 | 1 |
112676 | 112676 | 2020-05-04 | Nevada | California | 6057 | 41 | 1 |
115559 | 115559 | 2020-05-05 | Nevada | California | 6057 | 41 | 1 |
118518 | 118518 | 2020-05-06 | Nevada | California | 6057 | 41 | 1 |
121485 | 121485 | 2020-05-07 | Nevada | California | 6057 | 41 | 1 |
124465 | 124465 | 2020-05-08 | Nevada | California | 6057 | 41 | 1 |
127450 | 127450 | 2020-05-09 | Nevada | California | 6057 | 41 | 1 |
130440 | 130440 | 2020-05-10 | Nevada | California | 6057 | 41 | 1 |
133430 | 133430 | 2020-05-11 | Nevada | California | 6057 | 41 | 1 |
136420 | 136420 | 2020-05-12 | Nevada | California | 6057 | 41 | 1 |
139411 | 139411 | 2020-05-13 | Nevada | California | 6057 | 41 | 1 |
142407 | 142407 | 2020-05-14 | Nevada | California | 6057 | 41 | 1 |
145406 | 145406 | 2020-05-15 | Nevada | California | 6057 | 41 | 1 |
148410 | 148410 | 2020-05-16 | Nevada | California | 6057 | 41 | 1 |
151419 | 151419 | 2020-05-17 | Nevada | California | 6057 | 41 | 1 |
154431 | 154431 | 2020-05-18 | Nevada | California | 6057 | 41 | 1 |
157447 | 157447 | 2020-05-19 | Nevada | California | 6057 | 41 | 1 |
160473 | 160473 | 2020-05-20 | Nevada | California | 6057 | 41 | 1 |
163501 | 163501 | 2020-05-21 | Nevada | California | 6057 | 41 | 1 |
166533 | 166533 | 2020-05-22 | Nevada | California | 6057 | 41 | 1 |
169570 | 169570 | 2020-05-23 | Nevada | California | 6057 | 41 | 1 |
172611 | 172611 | 2020-05-24 | Nevada | California | 6057 | 41 | 1 |
175655 | 175655 | 2020-05-25 | Nevada | California | 6057 | 41 | 1 |
178699 | 178699 | 2020-05-26 | Nevada | California | 6057 | 41 | 1 |
181743 | 181743 | 2020-05-27 | Nevada | California | 6057 | 41 | 1 |
184797 | 184797 | 2020-05-28 | Nevada | California | 6057 | 41 | 1 |
187853 | 187853 | 2020-05-29 | Nevada | California | 6057 | 41 | 1 |
190918 | 190918 | 2020-05-30 | Nevada | California | 6057 | 41 | 1 |
193985 | 193985 | 2020-05-31 | Nevada | California | 6057 | 41 | 1 |
197055 | 197055 | 2020-06-01 | Nevada | California | 6057 | 42 | 1 |
200128 | 200128 | 2020-06-02 | Nevada | California | 6057 | 48 | 1 |
203204 | 203204 | 2020-06-03 | Nevada | California | 6057 | 49 | 1 |
206284 | 206284 | 2020-06-04 | Nevada | California | 6057 | 49 | 1 |
209365 | 209365 | 2020-06-05 | Nevada | California | 6057 | 50 | 1 |
212450 | 212450 | 2020-06-06 | Nevada | California | 6057 | 50 | 1 |
215537 | 215537 | 2020-06-07 | Nevada | California | 6057 | 50 | 1 |
218628 | 218628 | 2020-06-08 | Nevada | California | 6057 | 50 | 1 |
221723 | 221723 | 2020-06-09 | Nevada | California | 6057 | 50 | 1 |
224818 | 224818 | 2020-06-10 | Nevada | California | 6057 | 50 | 1 |
227920 | 227920 | 2020-06-11 | Nevada | California | 6057 | 52 | 1 |
231023 | 231023 | 2020-06-12 | Nevada | California | 6057 | 52 | 1 |
234129 | 234129 | 2020-06-13 | Nevada | California | 6057 | 52 | 1 |
237236 | 237236 | 2020-06-14 | Nevada | California | 6057 | 52 | 1 |
240344 | 240344 | 2020-06-15 | Nevada | California | 6057 | 55 | 1 |
243455 | 243455 | 2020-06-16 | Nevada | California | 6057 | 57 | 1 |
246568 | 246568 | 2020-06-17 | Nevada | California | 6057 | 67 | 1 |
249680 | 249680 | 2020-06-18 | Nevada | California | 6057 | 71 | 1 |
252795 | 252795 | 2020-06-19 | Nevada | California | 6057 | 75 | 1 |
255914 | 255914 | 2020-06-20 | Nevada | California | 6057 | 75 | 1 |
259041 | 259041 | 2020-06-21 | Nevada | California | 6057 | 75 | 1 |
262168 | 262168 | 2020-06-22 | Nevada | California | 6057 | 82 | 1 |
265296 | 265296 | 2020-06-23 | Nevada | California | 6057 | 92 | 1 |
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);