ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where county = "Crawford" and deaths = 10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
county 1
- Crawford · 74 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
992553 | 992553 | 2021-02-03 | Crawford | Indiana | 18025 | 852 | 10 |
989307 | 989307 | 2021-02-02 | Crawford | Indiana | 18025 | 847 | 10 |
986060 | 986060 | 2021-02-01 | Crawford | Indiana | 18025 | 841 | 10 |
982813 | 982813 | 2021-01-31 | Crawford | Indiana | 18025 | 834 | 10 |
979567 | 979567 | 2021-01-30 | Crawford | Indiana | 18025 | 829 | 10 |
976321 | 976321 | 2021-01-29 | Crawford | Indiana | 18025 | 825 | 10 |
973076 | 973076 | 2021-01-28 | Crawford | Indiana | 18025 | 819 | 10 |
969831 | 969831 | 2021-01-27 | Crawford | Indiana | 18025 | 811 | 10 |
966587 | 966587 | 2021-01-26 | Crawford | Indiana | 18025 | 811 | 10 |
963056 | 963056 | 2021-01-25 | Crawford | Georgia | 13079 | 541 | 10 |
963342 | 963342 | 2021-01-25 | Crawford | Indiana | 18025 | 811 | 10 |
959811 | 959811 | 2021-01-24 | Crawford | Georgia | 13079 | 535 | 10 |
960097 | 960097 | 2021-01-24 | Crawford | Indiana | 18025 | 808 | 10 |
956565 | 956565 | 2021-01-23 | Crawford | Georgia | 13079 | 532 | 10 |
956851 | 956851 | 2021-01-23 | Crawford | Indiana | 18025 | 801 | 10 |
953320 | 953320 | 2021-01-22 | Crawford | Georgia | 13079 | 532 | 10 |
953606 | 953606 | 2021-01-22 | Crawford | Indiana | 18025 | 794 | 10 |
950075 | 950075 | 2021-01-21 | Crawford | Georgia | 13079 | 525 | 10 |
950361 | 950361 | 2021-01-21 | Crawford | Indiana | 18025 | 785 | 10 |
946829 | 946829 | 2021-01-20 | Crawford | Georgia | 13079 | 518 | 10 |
947115 | 947115 | 2021-01-20 | Crawford | Indiana | 18025 | 778 | 10 |
943582 | 943582 | 2021-01-19 | Crawford | Georgia | 13079 | 516 | 10 |
943868 | 943868 | 2021-01-19 | Crawford | Indiana | 18025 | 773 | 10 |
940337 | 940337 | 2021-01-18 | Crawford | Georgia | 13079 | 511 | 10 |
940623 | 940623 | 2021-01-18 | Crawford | Indiana | 18025 | 768 | 10 |
937092 | 937092 | 2021-01-17 | Crawford | Georgia | 13079 | 510 | 10 |
937378 | 937378 | 2021-01-17 | Crawford | Indiana | 18025 | 759 | 10 |
933847 | 933847 | 2021-01-16 | Crawford | Georgia | 13079 | 505 | 10 |
934133 | 934133 | 2021-01-16 | Crawford | Indiana | 18025 | 749 | 10 |
930602 | 930602 | 2021-01-15 | Crawford | Georgia | 13079 | 498 | 10 |
930888 | 930888 | 2021-01-15 | Crawford | Indiana | 18025 | 741 | 10 |
927357 | 927357 | 2021-01-14 | Crawford | Georgia | 13079 | 491 | 10 |
927643 | 927643 | 2021-01-14 | Crawford | Indiana | 18025 | 724 | 10 |
924111 | 924111 | 2021-01-13 | Crawford | Georgia | 13079 | 489 | 10 |
924397 | 924397 | 2021-01-13 | Crawford | Indiana | 18025 | 713 | 10 |
920866 | 920866 | 2021-01-12 | Crawford | Georgia | 13079 | 484 | 10 |
921152 | 921152 | 2021-01-12 | Crawford | Indiana | 18025 | 705 | 10 |
917907 | 917907 | 2021-01-11 | Crawford | Indiana | 18025 | 700 | 10 |
914662 | 914662 | 2021-01-10 | Crawford | Indiana | 18025 | 696 | 10 |
911417 | 911417 | 2021-01-09 | Crawford | Indiana | 18025 | 684 | 10 |
908172 | 908172 | 2021-01-08 | Crawford | Indiana | 18025 | 665 | 10 |
904926 | 904926 | 2021-01-07 | Crawford | Indiana | 18025 | 660 | 10 |
901681 | 901681 | 2021-01-06 | Crawford | Indiana | 18025 | 640 | 10 |
898436 | 898436 | 2021-01-05 | Crawford | Indiana | 18025 | 629 | 10 |
826239 | 826239 | 2020-12-13 | Crawford | Wisconsin | 55023 | 1505 | 10 |
822992 | 822992 | 2020-12-12 | Crawford | Wisconsin | 55023 | 1493 | 10 |
819746 | 819746 | 2020-12-11 | Crawford | Wisconsin | 55023 | 1481 | 10 |
816500 | 816500 | 2020-12-10 | Crawford | Wisconsin | 55023 | 1480 | 10 |
813254 | 813254 | 2020-12-09 | Crawford | Wisconsin | 55023 | 1461 | 10 |
765278 | 765278 | 2020-11-25 | Crawford | Illinois | 17033 | 1077 | 10 |
750714 | 750714 | 2020-11-20 | Crawford | Pennsylvania | 42039 | 1362 | 10 |
746710 | 746710 | 2020-11-19 | Crawford | Missouri | 29055 | 1029 | 10 |
743463 | 743463 | 2020-11-18 | Crawford | Missouri | 29055 | 1015 | 10 |
740216 | 740216 | 2020-11-17 | Crawford | Missouri | 29055 | 1005 | 10 |
736972 | 736972 | 2020-11-16 | Crawford | Missouri | 29055 | 983 | 10 |
733726 | 733726 | 2020-11-15 | Crawford | Missouri | 29055 | 961 | 10 |
730481 | 730481 | 2020-11-14 | Crawford | Missouri | 29055 | 961 | 10 |
727238 | 727238 | 2020-11-13 | Crawford | Missouri | 29055 | 907 | 10 |
723995 | 723995 | 2020-11-12 | Crawford | Missouri | 29055 | 892 | 10 |
720752 | 720752 | 2020-11-11 | Crawford | Missouri | 29055 | 852 | 10 |
717509 | 717509 | 2020-11-10 | Crawford | Missouri | 29055 | 846 | 10 |
674734 | 674734 | 2020-10-28 | Crawford | Kansas | 20037 | 1475 | 10 |
671492 | 671492 | 2020-10-27 | Crawford | Kansas | 20037 | 1446 | 10 |
668249 | 668249 | 2020-10-26 | Crawford | Kansas | 20037 | 1446 | 10 |
665005 | 665005 | 2020-10-25 | Crawford | Kansas | 20037 | 1421 | 10 |
661760 | 661760 | 2020-10-24 | Crawford | Kansas | 20037 | 1421 | 10 |
658516 | 658516 | 2020-10-23 | Crawford | Kansas | 20037 | 1421 | 10 |
613000 | 613000 | 2020-10-09 | Crawford | Iowa | 19047 | 1218 | 10 |
528077 | 528077 | 2020-09-13 | Crawford | Arkansas | 5033 | 1088 | 10 |
524841 | 524841 | 2020-09-12 | Crawford | Arkansas | 5033 | 1078 | 10 |
521605 | 521605 | 2020-09-11 | Crawford | Arkansas | 5033 | 1044 | 10 |
518368 | 518368 | 2020-09-10 | Crawford | Arkansas | 5033 | 1009 | 10 |
515133 | 515133 | 2020-09-09 | Crawford | Arkansas | 5033 | 1002 | 10 |
511900 | 511900 | 2020-09-08 | Crawford | Arkansas | 5033 | 1000 | 10 |
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);