ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 6053 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
3249 | 3249 | 2020-03-17 | Monterey | California | 6053 | 2 | 0 |
3803 | 3803 | 2020-03-18 | Monterey | California | 6053 | 2 | 0 |
4463 | 4463 | 2020-03-19 | Monterey | California | 6053 | 2 | 0 |
5238 | 5238 | 2020-03-20 | Monterey | California | 6053 | 5 | 0 |
6159 | 6159 | 2020-03-21 | Monterey | California | 6053 | 11 | 1 |
7193 | 7193 | 2020-03-22 | Monterey | California | 6053 | 14 | 1 |
8336 | 8336 | 2020-03-23 | Monterey | California | 6053 | 20 | 1 |
9579 | 9579 | 2020-03-24 | Monterey | California | 6053 | 20 | 1 |
10951 | 10951 | 2020-03-25 | Monterey | California | 6053 | 24 | 1 |
12496 | 12496 | 2020-03-26 | Monterey | California | 6053 | 24 | 1 |
14162 | 14162 | 2020-03-27 | Monterey | California | 6053 | 27 | 1 |
15944 | 15944 | 2020-03-28 | Monterey | California | 6053 | 27 | 1 |
17833 | 17833 | 2020-03-29 | Monterey | California | 6053 | 32 | 1 |
19810 | 19810 | 2020-03-30 | Monterey | California | 6053 | 36 | 1 |
21884 | 21884 | 2020-03-31 | Monterey | California | 6053 | 42 | 2 |
24042 | 24042 | 2020-04-01 | Monterey | California | 6053 | 42 | 2 |
26271 | 26271 | 2020-04-02 | Monterey | California | 6053 | 48 | 2 |
28570 | 28570 | 2020-04-03 | Monterey | California | 6053 | 53 | 2 |
30928 | 30928 | 2020-04-04 | Monterey | California | 6053 | 62 | 2 |
33334 | 33334 | 2020-04-05 | Monterey | California | 6053 | 62 | 2 |
35779 | 35779 | 2020-04-06 | Monterey | California | 6053 | 63 | 2 |
38268 | 38268 | 2020-04-07 | Monterey | California | 6053 | 64 | 2 |
40812 | 40812 | 2020-04-08 | Monterey | California | 6053 | 69 | 2 |
43384 | 43384 | 2020-04-09 | Monterey | California | 6053 | 71 | 3 |
45984 | 45984 | 2020-04-10 | Monterey | California | 6053 | 79 | 3 |
48614 | 48614 | 2020-04-11 | Monterey | California | 6053 | 82 | 3 |
51276 | 51276 | 2020-04-12 | Monterey | California | 6053 | 87 | 3 |
53955 | 53955 | 2020-04-13 | Monterey | California | 6053 | 87 | 3 |
56647 | 56647 | 2020-04-14 | Monterey | California | 6053 | 100 | 3 |
59355 | 59355 | 2020-04-15 | Monterey | California | 6053 | 108 | 3 |
62074 | 62074 | 2020-04-16 | Monterey | California | 6053 | 119 | 3 |
64807 | 64807 | 2020-04-17 | Monterey | California | 6053 | 119 | 3 |
67555 | 67555 | 2020-04-18 | Monterey | California | 6053 | 136 | 3 |
70317 | 70317 | 2020-04-19 | Monterey | California | 6053 | 141 | 4 |
73086 | 73086 | 2020-04-20 | Monterey | California | 6053 | 148 | 4 |
75862 | 75862 | 2020-04-21 | Monterey | California | 6053 | 150 | 4 |
78646 | 78646 | 2020-04-22 | Monterey | California | 6053 | 154 | 4 |
81440 | 81440 | 2020-04-23 | Monterey | California | 6053 | 164 | 4 |
84240 | 84240 | 2020-04-24 | Monterey | California | 6053 | 169 | 4 |
87048 | 87048 | 2020-04-25 | Monterey | California | 6053 | 176 | 4 |
89865 | 89865 | 2020-04-26 | Monterey | California | 6053 | 183 | 4 |
92683 | 92683 | 2020-04-27 | Monterey | California | 6053 | 185 | 4 |
95515 | 95515 | 2020-04-28 | Monterey | California | 6053 | 191 | 5 |
98360 | 98360 | 2020-04-29 | Monterey | California | 6053 | 206 | 5 |
101210 | 101210 | 2020-04-30 | Monterey | California | 6053 | 213 | 5 |
104065 | 104065 | 2020-05-01 | Monterey | California | 6053 | 222 | 5 |
106930 | 106930 | 2020-05-02 | Monterey | California | 6053 | 222 | 6 |
109799 | 109799 | 2020-05-03 | Monterey | California | 6053 | 225 | 6 |
112674 | 112674 | 2020-05-04 | Monterey | California | 6053 | 235 | 6 |
115557 | 115557 | 2020-05-05 | Monterey | California | 6053 | 237 | 6 |
118516 | 118516 | 2020-05-06 | Monterey | California | 6053 | 240 | 6 |
121483 | 121483 | 2020-05-07 | Monterey | California | 6053 | 246 | 6 |
124463 | 124463 | 2020-05-08 | Monterey | California | 6053 | 249 | 6 |
127448 | 127448 | 2020-05-09 | Monterey | California | 6053 | 265 | 6 |
130438 | 130438 | 2020-05-10 | Monterey | California | 6053 | 273 | 6 |
133428 | 133428 | 2020-05-11 | Monterey | California | 6053 | 282 | 6 |
136418 | 136418 | 2020-05-12 | Monterey | California | 6053 | 286 | 6 |
139409 | 139409 | 2020-05-13 | Monterey | California | 6053 | 298 | 6 |
142405 | 142405 | 2020-05-14 | Monterey | California | 6053 | 309 | 6 |
145404 | 145404 | 2020-05-15 | Monterey | California | 6053 | 317 | 8 |
148408 | 148408 | 2020-05-16 | Monterey | California | 6053 | 321 | 8 |
151417 | 151417 | 2020-05-17 | Monterey | California | 6053 | 329 | 8 |
154429 | 154429 | 2020-05-18 | Monterey | California | 6053 | 342 | 8 |
157445 | 157445 | 2020-05-19 | Monterey | California | 6053 | 345 | 8 |
160471 | 160471 | 2020-05-20 | Monterey | California | 6053 | 350 | 8 |
163499 | 163499 | 2020-05-21 | Monterey | California | 6053 | 356 | 8 |
166531 | 166531 | 2020-05-22 | Monterey | California | 6053 | 371 | 8 |
169568 | 169568 | 2020-05-23 | Monterey | California | 6053 | 395 | 8 |
172609 | 172609 | 2020-05-24 | Monterey | California | 6053 | 403 | 8 |
175653 | 175653 | 2020-05-25 | Monterey | California | 6053 | 413 | 8 |
178697 | 178697 | 2020-05-26 | Monterey | California | 6053 | 429 | 8 |
181741 | 181741 | 2020-05-27 | Monterey | California | 6053 | 441 | 8 |
184795 | 184795 | 2020-05-28 | Monterey | California | 6053 | 469 | 8 |
187851 | 187851 | 2020-05-29 | Monterey | California | 6053 | 477 | 10 |
190916 | 190916 | 2020-05-30 | Monterey | California | 6053 | 509 | 10 |
193983 | 193983 | 2020-05-31 | Monterey | California | 6053 | 530 | 10 |
197053 | 197053 | 2020-06-01 | Monterey | California | 6053 | 545 | 10 |
200126 | 200126 | 2020-06-02 | Monterey | California | 6053 | 571 | 10 |
203202 | 203202 | 2020-06-03 | Monterey | California | 6053 | 586 | 10 |
206282 | 206282 | 2020-06-04 | Monterey | California | 6053 | 621 | 10 |
209363 | 209363 | 2020-06-05 | Monterey | California | 6053 | 640 | 10 |
212448 | 212448 | 2020-06-06 | Monterey | California | 6053 | 667 | 10 |
215535 | 215535 | 2020-06-07 | Monterey | California | 6053 | 732 | 10 |
218626 | 218626 | 2020-06-08 | Monterey | California | 6053 | 751 | 10 |
221721 | 221721 | 2020-06-09 | Monterey | California | 6053 | 763 | 11 |
224816 | 224816 | 2020-06-10 | Monterey | California | 6053 | 791 | 11 |
227918 | 227918 | 2020-06-11 | Monterey | California | 6053 | 814 | 11 |
231021 | 231021 | 2020-06-12 | Monterey | California | 6053 | 865 | 11 |
234127 | 234127 | 2020-06-13 | Monterey | California | 6053 | 899 | 11 |
237234 | 237234 | 2020-06-14 | Monterey | California | 6053 | 949 | 12 |
240342 | 240342 | 2020-06-15 | Monterey | California | 6053 | 995 | 12 |
243453 | 243453 | 2020-06-16 | Monterey | California | 6053 | 1015 | 12 |
246566 | 246566 | 2020-06-17 | Monterey | California | 6053 | 1075 | 12 |
249678 | 249678 | 2020-06-18 | Monterey | California | 6053 | 1121 | 12 |
252793 | 252793 | 2020-06-19 | Monterey | California | 6053 | 1156 | 12 |
255912 | 255912 | 2020-06-20 | Monterey | California | 6053 | 1181 | 12 |
259039 | 259039 | 2020-06-21 | Monterey | California | 6053 | 1225 | 12 |
262166 | 262166 | 2020-06-22 | Monterey | California | 6053 | 1291 | 12 |
265294 | 265294 | 2020-06-23 | Monterey | California | 6053 | 1341 | 12 |
268424 | 268424 | 2020-06-24 | Monterey | California | 6053 | 1397 | 12 |
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);