ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where county = "Rice", deaths = 8 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
639522 | 639522 | 2020-10-17 | Rice | Minnesota | 27131 | 1555 | 8 |
636276 | 636276 | 2020-10-16 | Rice | Minnesota | 27131 | 1522 | 8 |
633030 | 633030 | 2020-10-15 | Rice | Minnesota | 27131 | 1508 | 8 |
629785 | 629785 | 2020-10-14 | Rice | Minnesota | 27131 | 1506 | 8 |
626541 | 626541 | 2020-10-13 | Rice | Minnesota | 27131 | 1498 | 8 |
623299 | 623299 | 2020-10-12 | Rice | Minnesota | 27131 | 1492 | 8 |
620056 | 620056 | 2020-10-11 | Rice | Minnesota | 27131 | 1479 | 8 |
616814 | 616814 | 2020-10-10 | Rice | Minnesota | 27131 | 1468 | 8 |
613573 | 613573 | 2020-10-09 | Rice | Minnesota | 27131 | 1454 | 8 |
610331 | 610331 | 2020-10-08 | Rice | Minnesota | 27131 | 1428 | 8 |
607089 | 607089 | 2020-10-07 | Rice | Minnesota | 27131 | 1419 | 8 |
603846 | 603846 | 2020-10-06 | Rice | Minnesota | 27131 | 1406 | 8 |
600604 | 600604 | 2020-10-05 | Rice | Minnesota | 27131 | 1398 | 8 |
597361 | 597361 | 2020-10-04 | Rice | Minnesota | 27131 | 1398 | 8 |
594120 | 594120 | 2020-10-03 | Rice | Minnesota | 27131 | 1393 | 8 |
590879 | 590879 | 2020-10-02 | Rice | Minnesota | 27131 | 1377 | 8 |
587638 | 587638 | 2020-10-01 | Rice | Minnesota | 27131 | 1364 | 8 |
584398 | 584398 | 2020-09-30 | Rice | Minnesota | 27131 | 1351 | 8 |
581157 | 581157 | 2020-09-29 | Rice | Minnesota | 27131 | 1347 | 8 |
577916 | 577916 | 2020-09-28 | Rice | Minnesota | 27131 | 1343 | 8 |
574675 | 574675 | 2020-09-27 | Rice | Minnesota | 27131 | 1343 | 8 |
571432 | 571432 | 2020-09-26 | Rice | Minnesota | 27131 | 1335 | 8 |
568190 | 568190 | 2020-09-25 | Rice | Minnesota | 27131 | 1328 | 8 |
564950 | 564950 | 2020-09-24 | Rice | Minnesota | 27131 | 1322 | 8 |
561710 | 561710 | 2020-09-23 | Rice | Minnesota | 27131 | 1311 | 8 |
558473 | 558473 | 2020-09-22 | Rice | Minnesota | 27131 | 1309 | 8 |
555236 | 555236 | 2020-09-21 | Rice | Minnesota | 27131 | 1308 | 8 |
551998 | 551998 | 2020-09-20 | Rice | Minnesota | 27131 | 1301 | 8 |
548759 | 548759 | 2020-09-19 | Rice | Minnesota | 27131 | 1297 | 8 |
545521 | 545521 | 2020-09-18 | Rice | Minnesota | 27131 | 1290 | 8 |
542284 | 542284 | 2020-09-17 | Rice | Minnesota | 27131 | 1279 | 8 |
539048 | 539048 | 2020-09-16 | Rice | Minnesota | 27131 | 1274 | 8 |
535811 | 535811 | 2020-09-15 | Rice | Minnesota | 27131 | 1267 | 8 |
532576 | 532576 | 2020-09-14 | Rice | Minnesota | 27131 | 1264 | 8 |
529340 | 529340 | 2020-09-13 | Rice | Minnesota | 27131 | 1261 | 8 |
526104 | 526104 | 2020-09-12 | Rice | Minnesota | 27131 | 1255 | 8 |
522868 | 522868 | 2020-09-11 | Rice | Minnesota | 27131 | 1247 | 8 |
519631 | 519631 | 2020-09-10 | Rice | Minnesota | 27131 | 1241 | 8 |
516396 | 516396 | 2020-09-09 | Rice | Minnesota | 27131 | 1234 | 8 |
513162 | 513162 | 2020-09-08 | Rice | Minnesota | 27131 | 1233 | 8 |
509930 | 509930 | 2020-09-07 | Rice | Minnesota | 27131 | 1232 | 8 |
506697 | 506697 | 2020-09-06 | Rice | Minnesota | 27131 | 1229 | 8 |
503464 | 503464 | 2020-09-05 | Rice | Minnesota | 27131 | 1223 | 8 |
500230 | 500230 | 2020-09-04 | Rice | Minnesota | 27131 | 1216 | 8 |
496996 | 496996 | 2020-09-03 | Rice | Minnesota | 27131 | 1211 | 8 |
493763 | 493763 | 2020-09-02 | Rice | Minnesota | 27131 | 1207 | 8 |
490529 | 490529 | 2020-09-01 | Rice | Minnesota | 27131 | 1199 | 8 |
487296 | 487296 | 2020-08-31 | Rice | Minnesota | 27131 | 1193 | 8 |
484062 | 484062 | 2020-08-30 | Rice | Minnesota | 27131 | 1185 | 8 |
480827 | 480827 | 2020-08-29 | Rice | Minnesota | 27131 | 1174 | 8 |
477595 | 477595 | 2020-08-28 | Rice | Minnesota | 27131 | 1163 | 8 |
474362 | 474362 | 2020-08-27 | Rice | Minnesota | 27131 | 1159 | 8 |
471130 | 471130 | 2020-08-26 | Rice | Minnesota | 27131 | 1151 | 8 |
467900 | 467900 | 2020-08-25 | Rice | Minnesota | 27131 | 1150 | 8 |
464671 | 464671 | 2020-08-24 | Rice | Minnesota | 27131 | 1147 | 8 |
461440 | 461440 | 2020-08-23 | Rice | Minnesota | 27131 | 1120 | 8 |
458213 | 458213 | 2020-08-22 | Rice | Minnesota | 27131 | 1116 | 8 |
454985 | 454985 | 2020-08-21 | Rice | Minnesota | 27131 | 1110 | 8 |
451757 | 451757 | 2020-08-20 | Rice | Minnesota | 27131 | 1096 | 8 |
448529 | 448529 | 2020-08-19 | Rice | Minnesota | 27131 | 1078 | 8 |
445303 | 445303 | 2020-08-18 | Rice | Minnesota | 27131 | 1073 | 8 |
442077 | 442077 | 2020-08-17 | Rice | Minnesota | 27131 | 1067 | 8 |
438850 | 438850 | 2020-08-16 | Rice | Minnesota | 27131 | 1065 | 8 |
435625 | 435625 | 2020-08-15 | Rice | Minnesota | 27131 | 1055 | 8 |
432399 | 432399 | 2020-08-14 | Rice | Minnesota | 27131 | 1048 | 8 |
429172 | 429172 | 2020-08-13 | Rice | Minnesota | 27131 | 1046 | 8 |
425948 | 425948 | 2020-08-12 | Rice | Minnesota | 27131 | 1042 | 8 |
422726 | 422726 | 2020-08-11 | Rice | Minnesota | 27131 | 1038 | 8 |
419504 | 419504 | 2020-08-10 | Rice | Minnesota | 27131 | 1038 | 8 |
416283 | 416283 | 2020-08-09 | Rice | Minnesota | 27131 | 1032 | 8 |
413063 | 413063 | 2020-08-08 | Rice | Minnesota | 27131 | 1029 | 8 |
409843 | 409843 | 2020-08-07 | Rice | Minnesota | 27131 | 1019 | 8 |
406623 | 406623 | 2020-08-06 | Rice | Minnesota | 27131 | 1013 | 8 |
403405 | 403405 | 2020-08-05 | Rice | Minnesota | 27131 | 1006 | 8 |
400188 | 400188 | 2020-08-04 | Rice | Minnesota | 27131 | 1002 | 8 |
396974 | 396974 | 2020-08-03 | Rice | Minnesota | 27131 | 999 | 8 |
393758 | 393758 | 2020-08-02 | Rice | Minnesota | 27131 | 989 | 8 |
390541 | 390541 | 2020-08-01 | Rice | Minnesota | 27131 | 982 | 8 |
387324 | 387324 | 2020-07-31 | Rice | Minnesota | 27131 | 975 | 8 |
384106 | 384106 | 2020-07-30 | Rice | Minnesota | 27131 | 970 | 8 |
380889 | 380889 | 2020-07-29 | Rice | Minnesota | 27131 | 961 | 8 |
377672 | 377672 | 2020-07-28 | Rice | Minnesota | 27131 | 956 | 8 |
374457 | 374457 | 2020-07-27 | Rice | Minnesota | 27131 | 953 | 8 |
371245 | 371245 | 2020-07-26 | Rice | Minnesota | 27131 | 947 | 8 |
368035 | 368035 | 2020-07-25 | Rice | Minnesota | 27131 | 944 | 8 |
364827 | 364827 | 2020-07-24 | Rice | Minnesota | 27131 | 934 | 8 |
361620 | 361620 | 2020-07-23 | Rice | Minnesota | 27131 | 928 | 8 |
358415 | 358415 | 2020-07-22 | Rice | Minnesota | 27131 | 924 | 8 |
355212 | 355212 | 2020-07-21 | Rice | Minnesota | 27131 | 919 | 8 |
352010 | 352010 | 2020-07-20 | Rice | Minnesota | 27131 | 915 | 8 |
348810 | 348810 | 2020-07-19 | Rice | Minnesota | 27131 | 915 | 8 |
345609 | 345609 | 2020-07-18 | Rice | Minnesota | 27131 | 912 | 8 |
342409 | 342409 | 2020-07-17 | Rice | Minnesota | 27131 | 910 | 8 |
339213 | 339213 | 2020-07-16 | Rice | Minnesota | 27131 | 905 | 8 |
336017 | 336017 | 2020-07-15 | Rice | Minnesota | 27131 | 898 | 8 |
332824 | 332824 | 2020-07-14 | Rice | Minnesota | 27131 | 895 | 8 |
329637 | 329637 | 2020-07-13 | Rice | Minnesota | 27131 | 892 | 8 |
326451 | 326451 | 2020-07-12 | Rice | Minnesota | 27131 | 884 | 8 |
323268 | 323268 | 2020-07-11 | Rice | Minnesota | 27131 | 879 | 8 |
320089 | 320089 | 2020-07-10 | Rice | Minnesota | 27131 | 873 | 8 |
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);