ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Montcalm" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636185 | 636185 | 2020-10-16 | Montcalm | Michigan | 26117 | 464 | 8 |
632939 | 632939 | 2020-10-15 | Montcalm | Michigan | 26117 | 456 | 7 |
629694 | 629694 | 2020-10-14 | Montcalm | Michigan | 26117 | 436 | 7 |
626450 | 626450 | 2020-10-13 | Montcalm | Michigan | 26117 | 430 | 7 |
623208 | 623208 | 2020-10-12 | Montcalm | Michigan | 26117 | 416 | 7 |
619965 | 619965 | 2020-10-11 | Montcalm | Michigan | 26117 | 394 | 7 |
616723 | 616723 | 2020-10-10 | Montcalm | Michigan | 26117 | 394 | 7 |
613482 | 613482 | 2020-10-09 | Montcalm | Michigan | 26117 | 391 | 7 |
610240 | 610240 | 2020-10-08 | Montcalm | Michigan | 26117 | 387 | 7 |
606998 | 606998 | 2020-10-07 | Montcalm | Michigan | 26117 | 382 | 7 |
603755 | 603755 | 2020-10-06 | Montcalm | Michigan | 26117 | 378 | 7 |
600513 | 600513 | 2020-10-05 | Montcalm | Michigan | 26117 | 374 | 7 |
597270 | 597270 | 2020-10-04 | Montcalm | Michigan | 26117 | 363 | 7 |
594029 | 594029 | 2020-10-03 | Montcalm | Michigan | 26117 | 363 | 7 |
590788 | 590788 | 2020-10-02 | Montcalm | Michigan | 26117 | 358 | 7 |
587547 | 587547 | 2020-10-01 | Montcalm | Michigan | 26117 | 349 | 7 |
584307 | 584307 | 2020-09-30 | Montcalm | Michigan | 26117 | 344 | 6 |
581066 | 581066 | 2020-09-29 | Montcalm | Michigan | 26117 | 340 | 6 |
577825 | 577825 | 2020-09-28 | Montcalm | Michigan | 26117 | 327 | 6 |
574584 | 574584 | 2020-09-27 | Montcalm | Michigan | 26117 | 317 | 6 |
571341 | 571341 | 2020-09-26 | Montcalm | Michigan | 26117 | 317 | 6 |
568099 | 568099 | 2020-09-25 | Montcalm | Michigan | 26117 | 314 | 5 |
564859 | 564859 | 2020-09-24 | Montcalm | Michigan | 26117 | 310 | 5 |
561619 | 561619 | 2020-09-23 | Montcalm | Michigan | 26117 | 306 | 5 |
558382 | 558382 | 2020-09-22 | Montcalm | Michigan | 26117 | 302 | 5 |
555145 | 555145 | 2020-09-21 | Montcalm | Michigan | 26117 | 296 | 5 |
551907 | 551907 | 2020-09-20 | Montcalm | Michigan | 26117 | 291 | 5 |
548668 | 548668 | 2020-09-19 | Montcalm | Michigan | 26117 | 291 | 5 |
545430 | 545430 | 2020-09-18 | Montcalm | Michigan | 26117 | 287 | 5 |
542193 | 542193 | 2020-09-17 | Montcalm | Michigan | 26117 | 280 | 5 |
538957 | 538957 | 2020-09-16 | Montcalm | Michigan | 26117 | 277 | 4 |
535720 | 535720 | 2020-09-15 | Montcalm | Michigan | 26117 | 275 | 4 |
532485 | 532485 | 2020-09-14 | Montcalm | Michigan | 26117 | 272 | 4 |
529249 | 529249 | 2020-09-13 | Montcalm | Michigan | 26117 | 259 | 4 |
526013 | 526013 | 2020-09-12 | Montcalm | Michigan | 26117 | 259 | 4 |
522777 | 522777 | 2020-09-11 | Montcalm | Michigan | 26117 | 260 | 4 |
519540 | 519540 | 2020-09-10 | Montcalm | Michigan | 26117 | 255 | 4 |
516305 | 516305 | 2020-09-09 | Montcalm | Michigan | 26117 | 252 | 4 |
513071 | 513071 | 2020-09-08 | Montcalm | Michigan | 26117 | 251 | 4 |
509839 | 509839 | 2020-09-07 | Montcalm | Michigan | 26117 | 248 | 4 |
506606 | 506606 | 2020-09-06 | Montcalm | Michigan | 26117 | 243 | 4 |
503373 | 503373 | 2020-09-05 | Montcalm | Michigan | 26117 | 243 | 4 |
500139 | 500139 | 2020-09-04 | Montcalm | Michigan | 26117 | 240 | 4 |
496905 | 496905 | 2020-09-03 | Montcalm | Michigan | 26117 | 237 | 4 |
493672 | 493672 | 2020-09-02 | Montcalm | Michigan | 26117 | 230 | 4 |
490438 | 490438 | 2020-09-01 | Montcalm | Michigan | 26117 | 232 | 4 |
487205 | 487205 | 2020-08-31 | Montcalm | Michigan | 26117 | 226 | 4 |
483971 | 483971 | 2020-08-30 | Montcalm | Michigan | 26117 | 227 | 4 |
480736 | 480736 | 2020-08-29 | Montcalm | Michigan | 26117 | 224 | 3 |
477504 | 477504 | 2020-08-28 | Montcalm | Michigan | 26117 | 222 | 3 |
474271 | 474271 | 2020-08-27 | Montcalm | Michigan | 26117 | 219 | 3 |
471039 | 471039 | 2020-08-26 | Montcalm | Michigan | 26117 | 217 | 3 |
467809 | 467809 | 2020-08-25 | Montcalm | Michigan | 26117 | 216 | 3 |
464580 | 464580 | 2020-08-24 | Montcalm | Michigan | 26117 | 213 | 3 |
461349 | 461349 | 2020-08-23 | Montcalm | Michigan | 26117 | 213 | 3 |
458122 | 458122 | 2020-08-22 | Montcalm | Michigan | 26117 | 212 | 3 |
454894 | 454894 | 2020-08-21 | Montcalm | Michigan | 26117 | 209 | 3 |
451666 | 451666 | 2020-08-20 | Montcalm | Michigan | 26117 | 209 | 3 |
448438 | 448438 | 2020-08-19 | Montcalm | Michigan | 26117 | 209 | 3 |
445212 | 445212 | 2020-08-18 | Montcalm | Michigan | 26117 | 209 | 3 |
441986 | 441986 | 2020-08-17 | Montcalm | Michigan | 26117 | 206 | 3 |
438759 | 438759 | 2020-08-16 | Montcalm | Michigan | 26117 | 206 | 2 |
435534 | 435534 | 2020-08-15 | Montcalm | Michigan | 26117 | 206 | 2 |
432308 | 432308 | 2020-08-14 | Montcalm | Michigan | 26117 | 203 | 2 |
429081 | 429081 | 2020-08-13 | Montcalm | Michigan | 26117 | 201 | 2 |
425857 | 425857 | 2020-08-12 | Montcalm | Michigan | 26117 | 195 | 1 |
422635 | 422635 | 2020-08-11 | Montcalm | Michigan | 26117 | 197 | 1 |
419413 | 419413 | 2020-08-10 | Montcalm | Michigan | 26117 | 194 | 1 |
416192 | 416192 | 2020-08-09 | Montcalm | Michigan | 26117 | 193 | 1 |
412972 | 412972 | 2020-08-08 | Montcalm | Michigan | 26117 | 190 | 1 |
409752 | 409752 | 2020-08-07 | Montcalm | Michigan | 26117 | 187 | 1 |
406532 | 406532 | 2020-08-06 | Montcalm | Michigan | 26117 | 186 | 1 |
403314 | 403314 | 2020-08-05 | Montcalm | Michigan | 26117 | 183 | 1 |
400097 | 400097 | 2020-08-04 | Montcalm | Michigan | 26117 | 183 | 1 |
396883 | 396883 | 2020-08-03 | Montcalm | Michigan | 26117 | 183 | 1 |
393667 | 393667 | 2020-08-02 | Montcalm | Michigan | 26117 | 182 | 1 |
390450 | 390450 | 2020-08-01 | Montcalm | Michigan | 26117 | 181 | 1 |
387233 | 387233 | 2020-07-31 | Montcalm | Michigan | 26117 | 176 | 1 |
384015 | 384015 | 2020-07-30 | Montcalm | Michigan | 26117 | 177 | 1 |
380798 | 380798 | 2020-07-29 | Montcalm | Michigan | 26117 | 175 | 1 |
377581 | 377581 | 2020-07-28 | Montcalm | Michigan | 26117 | 175 | 1 |
374366 | 374366 | 2020-07-27 | Montcalm | Michigan | 26117 | 174 | 1 |
371154 | 371154 | 2020-07-26 | Montcalm | Michigan | 26117 | 170 | 1 |
367944 | 367944 | 2020-07-25 | Montcalm | Michigan | 26117 | 169 | 1 |
364737 | 364737 | 2020-07-24 | Montcalm | Michigan | 26117 | 170 | 1 |
361530 | 361530 | 2020-07-23 | Montcalm | Michigan | 26117 | 167 | 1 |
358325 | 358325 | 2020-07-22 | Montcalm | Michigan | 26117 | 162 | 1 |
355122 | 355122 | 2020-07-21 | Montcalm | Michigan | 26117 | 159 | 1 |
351920 | 351920 | 2020-07-20 | Montcalm | Michigan | 26117 | 157 | 1 |
348720 | 348720 | 2020-07-19 | Montcalm | Michigan | 26117 | 153 | 1 |
345519 | 345519 | 2020-07-18 | Montcalm | Michigan | 26117 | 149 | 1 |
342319 | 342319 | 2020-07-17 | Montcalm | Michigan | 26117 | 146 | 1 |
339123 | 339123 | 2020-07-16 | Montcalm | Michigan | 26117 | 137 | 1 |
335927 | 335927 | 2020-07-15 | Montcalm | Michigan | 26117 | 131 | 1 |
332734 | 332734 | 2020-07-14 | Montcalm | Michigan | 26117 | 130 | 1 |
329547 | 329547 | 2020-07-13 | Montcalm | Michigan | 26117 | 129 | 1 |
326361 | 326361 | 2020-07-12 | Montcalm | Michigan | 26117 | 127 | 1 |
323178 | 323178 | 2020-07-11 | Montcalm | Michigan | 26117 | 127 | 1 |
319999 | 319999 | 2020-07-10 | Montcalm | Michigan | 26117 | 124 | 1 |
316824 | 316824 | 2020-07-09 | Montcalm | Michigan | 26117 | 122 | 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);