ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Merced" and state = "California" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
9577 | 9577 | 2020-03-24 | Merced | California | 6047 | 1 | 0 |
10949 | 10949 | 2020-03-25 | Merced | California | 6047 | 1 | 0 |
12494 | 12494 | 2020-03-26 | Merced | California | 6047 | 4 | 0 |
14160 | 14160 | 2020-03-27 | Merced | California | 6047 | 7 | 0 |
15942 | 15942 | 2020-03-28 | Merced | California | 6047 | 7 | 0 |
17831 | 17831 | 2020-03-29 | Merced | California | 6047 | 8 | 0 |
19808 | 19808 | 2020-03-30 | Merced | California | 6047 | 9 | 0 |
21882 | 21882 | 2020-03-31 | Merced | California | 6047 | 10 | 0 |
24040 | 24040 | 2020-04-01 | Merced | California | 6047 | 10 | 0 |
26269 | 26269 | 2020-04-02 | Merced | California | 6047 | 16 | 0 |
28568 | 28568 | 2020-04-03 | Merced | California | 6047 | 16 | 0 |
30926 | 30926 | 2020-04-04 | Merced | California | 6047 | 16 | 0 |
33332 | 33332 | 2020-04-05 | Merced | California | 6047 | 29 | 1 |
35777 | 35777 | 2020-04-06 | Merced | California | 6047 | 29 | 1 |
38266 | 38266 | 2020-04-07 | Merced | California | 6047 | 34 | 1 |
40810 | 40810 | 2020-04-08 | Merced | California | 6047 | 40 | 3 |
43382 | 43382 | 2020-04-09 | Merced | California | 6047 | 40 | 3 |
45982 | 45982 | 2020-04-10 | Merced | California | 6047 | 59 | 3 |
48612 | 48612 | 2020-04-11 | Merced | California | 6047 | 64 | 3 |
51274 | 51274 | 2020-04-12 | Merced | California | 6047 | 65 | 3 |
53953 | 53953 | 2020-04-13 | Merced | California | 6047 | 69 | 3 |
56645 | 56645 | 2020-04-14 | Merced | California | 6047 | 74 | 3 |
59353 | 59353 | 2020-04-15 | Merced | California | 6047 | 78 | 3 |
62072 | 62072 | 2020-04-16 | Merced | California | 6047 | 82 | 3 |
64805 | 64805 | 2020-04-17 | Merced | California | 6047 | 85 | 3 |
67553 | 67553 | 2020-04-18 | Merced | California | 6047 | 87 | 3 |
70315 | 70315 | 2020-04-19 | Merced | California | 6047 | 90 | 3 |
73084 | 73084 | 2020-04-20 | Merced | California | 6047 | 90 | 3 |
75860 | 75860 | 2020-04-21 | Merced | California | 6047 | 92 | 3 |
78644 | 78644 | 2020-04-22 | Merced | California | 6047 | 94 | 3 |
81438 | 81438 | 2020-04-23 | Merced | California | 6047 | 100 | 3 |
84238 | 84238 | 2020-04-24 | Merced | California | 6047 | 102 | 3 |
87046 | 87046 | 2020-04-25 | Merced | California | 6047 | 102 | 3 |
89863 | 89863 | 2020-04-26 | Merced | California | 6047 | 105 | 3 |
92681 | 92681 | 2020-04-27 | Merced | California | 6047 | 110 | 3 |
95513 | 95513 | 2020-04-28 | Merced | California | 6047 | 116 | 3 |
98358 | 98358 | 2020-04-29 | Merced | California | 6047 | 118 | 3 |
101208 | 101208 | 2020-04-30 | Merced | California | 6047 | 125 | 3 |
104063 | 104063 | 2020-05-01 | Merced | California | 6047 | 134 | 3 |
106928 | 106928 | 2020-05-02 | Merced | California | 6047 | 140 | 3 |
109797 | 109797 | 2020-05-03 | Merced | California | 6047 | 142 | 3 |
112672 | 112672 | 2020-05-04 | Merced | California | 6047 | 146 | 3 |
115555 | 115555 | 2020-05-05 | Merced | California | 6047 | 146 | 3 |
118514 | 118514 | 2020-05-06 | Merced | California | 6047 | 152 | 3 |
121481 | 121481 | 2020-05-07 | Merced | California | 6047 | 155 | 3 |
124461 | 124461 | 2020-05-08 | Merced | California | 6047 | 163 | 3 |
127446 | 127446 | 2020-05-09 | Merced | California | 6047 | 163 | 3 |
130436 | 130436 | 2020-05-10 | Merced | California | 6047 | 163 | 3 |
133426 | 133426 | 2020-05-11 | Merced | California | 6047 | 173 | 3 |
136416 | 136416 | 2020-05-12 | Merced | California | 6047 | 177 | 4 |
139407 | 139407 | 2020-05-13 | Merced | California | 6047 | 180 | 4 |
142403 | 142403 | 2020-05-14 | Merced | California | 6047 | 189 | 4 |
145402 | 145402 | 2020-05-15 | Merced | California | 6047 | 200 | 6 |
148406 | 148406 | 2020-05-16 | Merced | California | 6047 | 200 | 6 |
151415 | 151415 | 2020-05-17 | Merced | California | 6047 | 201 | 6 |
154427 | 154427 | 2020-05-18 | Merced | California | 6047 | 220 | 6 |
157443 | 157443 | 2020-05-19 | Merced | California | 6047 | 222 | 6 |
160469 | 160469 | 2020-05-20 | Merced | California | 6047 | 222 | 6 |
163497 | 163497 | 2020-05-21 | Merced | California | 6047 | 234 | 6 |
166529 | 166529 | 2020-05-22 | Merced | California | 6047 | 251 | 6 |
169566 | 169566 | 2020-05-23 | Merced | California | 6047 | 251 | 6 |
172607 | 172607 | 2020-05-24 | Merced | California | 6047 | 251 | 6 |
175651 | 175651 | 2020-05-25 | Merced | California | 6047 | 258 | 6 |
178695 | 178695 | 2020-05-26 | Merced | California | 6047 | 273 | 7 |
181739 | 181739 | 2020-05-27 | Merced | California | 6047 | 278 | 7 |
184793 | 184793 | 2020-05-28 | Merced | California | 6047 | 280 | 7 |
187849 | 187849 | 2020-05-29 | Merced | California | 6047 | 283 | 7 |
190914 | 190914 | 2020-05-30 | Merced | California | 6047 | 285 | 7 |
193981 | 193981 | 2020-05-31 | Merced | California | 6047 | 285 | 7 |
197051 | 197051 | 2020-06-01 | Merced | California | 6047 | 301 | 7 |
200124 | 200124 | 2020-06-02 | Merced | California | 6047 | 308 | 7 |
203200 | 203200 | 2020-06-03 | Merced | California | 6047 | 310 | 7 |
206280 | 206280 | 2020-06-04 | Merced | California | 6047 | 320 | 7 |
209361 | 209361 | 2020-06-05 | Merced | California | 6047 | 334 | 7 |
212446 | 212446 | 2020-06-06 | Merced | California | 6047 | 334 | 7 |
215533 | 215533 | 2020-06-07 | Merced | California | 6047 | 334 | 7 |
218624 | 218624 | 2020-06-08 | Merced | California | 6047 | 367 | 7 |
221719 | 221719 | 2020-06-09 | Merced | California | 6047 | 372 | 7 |
224814 | 224814 | 2020-06-10 | Merced | California | 6047 | 387 | 7 |
227916 | 227916 | 2020-06-11 | Merced | California | 6047 | 391 | 7 |
231019 | 231019 | 2020-06-12 | Merced | California | 6047 | 409 | 7 |
234125 | 234125 | 2020-06-13 | Merced | California | 6047 | 409 | 7 |
237232 | 237232 | 2020-06-14 | Merced | California | 6047 | 409 | 7 |
240340 | 240340 | 2020-06-15 | Merced | California | 6047 | 409 | 7 |
243451 | 243451 | 2020-06-16 | Merced | California | 6047 | 470 | 7 |
246564 | 246564 | 2020-06-17 | Merced | California | 6047 | 518 | 8 |
249676 | 249676 | 2020-06-18 | Merced | California | 6047 | 538 | 8 |
252791 | 252791 | 2020-06-19 | Merced | California | 6047 | 564 | 8 |
255910 | 255910 | 2020-06-20 | Merced | California | 6047 | 564 | 8 |
259037 | 259037 | 2020-06-21 | Merced | California | 6047 | 566 | 8 |
262164 | 262164 | 2020-06-22 | Merced | California | 6047 | 661 | 9 |
265292 | 265292 | 2020-06-23 | Merced | California | 6047 | 710 | 9 |
268422 | 268422 | 2020-06-24 | Merced | California | 6047 | 741 | 10 |
271557 | 271557 | 2020-06-25 | Merced | California | 6047 | 791 | 11 |
274697 | 274697 | 2020-06-26 | Merced | California | 6047 | 824 | 11 |
277845 | 277845 | 2020-06-27 | Merced | California | 6047 | 824 | 11 |
280992 | 280992 | 2020-06-28 | Merced | California | 6047 | 824 | 11 |
284138 | 284138 | 2020-06-29 | Merced | California | 6047 | 824 | 11 |
287284 | 287284 | 2020-06-30 | Merced | California | 6047 | 848 | 11 |
290435 | 290435 | 2020-07-01 | Merced | California | 6047 | 1131 | 11 |
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);