ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
235 rows where county = "Crawford" and deaths = 14 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 11
county 1
- Crawford · 235 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534549 | 534549 | 2020-09-15 | Crawford | Arkansas | 5033 | 1127 | 14 |
537785 | 537785 | 2020-09-16 | Crawford | Arkansas | 5033 | 1144 | 14 |
655176 | 655176 | 2020-10-22 | Crawford | Iowa | 19047 | 1341 | 14 |
658421 | 658421 | 2020-10-23 | Crawford | Iowa | 19047 | 1344 | 14 |
661665 | 661665 | 2020-10-24 | Crawford | Iowa | 19047 | 1352 | 14 |
664910 | 664910 | 2020-10-25 | Crawford | Iowa | 19047 | 1355 | 14 |
668154 | 668154 | 2020-10-26 | Crawford | Iowa | 19047 | 1361 | 14 |
671397 | 671397 | 2020-10-27 | Crawford | Iowa | 19047 | 1364 | 14 |
674639 | 674639 | 2020-10-28 | Crawford | Iowa | 19047 | 1370 | 14 |
677882 | 677882 | 2020-10-29 | Crawford | Iowa | 19047 | 1389 | 14 |
697437 | 697437 | 2020-11-04 | Crawford | Kansas | 20037 | 1605 | 14 |
700681 | 700681 | 2020-11-05 | Crawford | Kansas | 20037 | 1605 | 14 |
703923 | 703923 | 2020-11-06 | Crawford | Kansas | 20037 | 1656 | 14 |
707166 | 707166 | 2020-11-07 | Crawford | Kansas | 20037 | 1656 | 14 |
710410 | 710410 | 2020-11-08 | Crawford | Kansas | 20037 | 1656 | 14 |
713654 | 713654 | 2020-11-09 | Crawford | Kansas | 20037 | 1718 | 14 |
716898 | 716898 | 2020-11-10 | Crawford | Kansas | 20037 | 1718 | 14 |
720141 | 720141 | 2020-11-11 | Crawford | Kansas | 20037 | 1810 | 14 |
723384 | 723384 | 2020-11-12 | Crawford | Kansas | 20037 | 1810 | 14 |
726627 | 726627 | 2020-11-13 | Crawford | Kansas | 20037 | 1882 | 14 |
729870 | 729870 | 2020-11-14 | Crawford | Kansas | 20037 | 1882 | 14 |
731034 | 731034 | 2020-11-14 | Crawford | Ohio | 39033 | 892 | 14 |
733115 | 733115 | 2020-11-15 | Crawford | Kansas | 20037 | 1882 | 14 |
734280 | 734280 | 2020-11-15 | Crawford | Ohio | 39033 | 917 | 14 |
736361 | 736361 | 2020-11-16 | Crawford | Kansas | 20037 | 1944 | 14 |
737524 | 737524 | 2020-11-16 | Crawford | Ohio | 39033 | 948 | 14 |
739605 | 739605 | 2020-11-17 | Crawford | Kansas | 20037 | 1944 | 14 |
740770 | 740770 | 2020-11-17 | Crawford | Ohio | 39033 | 972 | 14 |
742852 | 742852 | 2020-11-18 | Crawford | Kansas | 20037 | 2026 | 14 |
766942 | 766942 | 2020-11-25 | Crawford | Pennsylvania | 42039 | 1635 | 14 |
785656 | 785656 | 2020-12-01 | Crawford | Missouri | 29055 | 1217 | 14 |
788901 | 788901 | 2020-12-02 | Crawford | Missouri | 29055 | 1228 | 14 |
791239 | 791239 | 2020-12-03 | Crawford | Illinois | 17033 | 1180 | 14 |
792146 | 792146 | 2020-12-03 | Crawford | Missouri | 29055 | 1239 | 14 |
795391 | 795391 | 2020-12-04 | Crawford | Missouri | 29055 | 1262 | 14 |
798636 | 798636 | 2020-12-05 | Crawford | Missouri | 29055 | 1277 | 14 |
801881 | 801881 | 2020-12-06 | Crawford | Missouri | 29055 | 1294 | 14 |
805126 | 805126 | 2020-12-07 | Crawford | Missouri | 29055 | 1312 | 14 |
808371 | 808371 | 2020-12-08 | Crawford | Missouri | 29055 | 1317 | 14 |
811616 | 811616 | 2020-12-09 | Crawford | Missouri | 29055 | 1330 | 14 |
814861 | 814861 | 2020-12-10 | Crawford | Missouri | 29055 | 1348 | 14 |
818107 | 818107 | 2020-12-11 | Crawford | Missouri | 29055 | 1348 | 14 |
821353 | 821353 | 2020-12-12 | Crawford | Missouri | 29055 | 1387 | 14 |
824599 | 824599 | 2020-12-13 | Crawford | Missouri | 29055 | 1399 | 14 |
827846 | 827846 | 2020-12-14 | Crawford | Missouri | 29055 | 1411 | 14 |
946317 | 946317 | 2021-01-19 | Crawford | Wisconsin | 55023 | 1664 | 14 |
949563 | 949563 | 2021-01-20 | Crawford | Wisconsin | 55023 | 1667 | 14 |
952808 | 952808 | 2021-01-21 | Crawford | Wisconsin | 55023 | 1668 | 14 |
956053 | 956053 | 2021-01-22 | Crawford | Wisconsin | 55023 | 1672 | 14 |
995799 | 995799 | 2021-02-04 | Crawford | Indiana | 18025 | 858 | 14 |
999045 | 999045 | 2021-02-05 | Crawford | Indiana | 18025 | 861 | 14 |
1002291 | 1002291 | 2021-02-06 | Crawford | Indiana | 18025 | 871 | 14 |
1005537 | 1005537 | 2021-02-07 | Crawford | Indiana | 18025 | 878 | 14 |
1008783 | 1008783 | 2021-02-08 | Crawford | Indiana | 18025 | 881 | 14 |
1012029 | 1012029 | 2021-02-09 | Crawford | Indiana | 18025 | 883 | 14 |
1015274 | 1015274 | 2021-02-10 | Crawford | Indiana | 18025 | 883 | 14 |
1018519 | 1018519 | 2021-02-11 | Crawford | Indiana | 18025 | 887 | 14 |
1021764 | 1021764 | 2021-02-12 | Crawford | Indiana | 18025 | 893 | 14 |
1025009 | 1025009 | 2021-02-13 | Crawford | Indiana | 18025 | 893 | 14 |
1028254 | 1028254 | 2021-02-14 | Crawford | Indiana | 18025 | 894 | 14 |
1031501 | 1031501 | 2021-02-15 | Crawford | Indiana | 18025 | 894 | 14 |
1034460 | 1034460 | 2021-02-16 | Crawford | Georgia | 13079 | 600 | 14 |
1034747 | 1034747 | 2021-02-16 | Crawford | Indiana | 18025 | 895 | 14 |
1037705 | 1037705 | 2021-02-17 | Crawford | Georgia | 13079 | 603 | 14 |
1037992 | 1037992 | 2021-02-17 | Crawford | Indiana | 18025 | 895 | 14 |
1041237 | 1041237 | 2021-02-18 | Crawford | Indiana | 18025 | 895 | 14 |
1044482 | 1044482 | 2021-02-19 | Crawford | Indiana | 18025 | 897 | 14 |
1047727 | 1047727 | 2021-02-20 | Crawford | Indiana | 18025 | 899 | 14 |
1050974 | 1050974 | 2021-02-21 | Crawford | Indiana | 18025 | 900 | 14 |
1054221 | 1054221 | 2021-02-22 | Crawford | Indiana | 18025 | 900 | 14 |
1057467 | 1057467 | 2021-02-23 | Crawford | Indiana | 18025 | 903 | 14 |
1060713 | 1060713 | 2021-02-24 | Crawford | Indiana | 18025 | 903 | 14 |
1063958 | 1063958 | 2021-02-25 | Crawford | Indiana | 18025 | 906 | 14 |
1067203 | 1067203 | 2021-02-26 | Crawford | Indiana | 18025 | 905 | 14 |
1070448 | 1070448 | 2021-02-27 | Crawford | Indiana | 18025 | 905 | 14 |
1073694 | 1073694 | 2021-02-28 | Crawford | Indiana | 18025 | 908 | 14 |
1076940 | 1076940 | 2021-03-01 | Crawford | Indiana | 18025 | 909 | 14 |
1080185 | 1080185 | 2021-03-02 | Crawford | Indiana | 18025 | 909 | 14 |
1083431 | 1083431 | 2021-03-03 | Crawford | Indiana | 18025 | 912 | 14 |
1086677 | 1086677 | 2021-03-04 | Crawford | Indiana | 18025 | 919 | 14 |
1089922 | 1089922 | 2021-03-05 | Crawford | Indiana | 18025 | 922 | 14 |
1093168 | 1093168 | 2021-03-06 | Crawford | Indiana | 18025 | 923 | 14 |
1096414 | 1096414 | 2021-03-07 | Crawford | Indiana | 18025 | 927 | 14 |
1099662 | 1099662 | 2021-03-08 | Crawford | Indiana | 18025 | 927 | 14 |
1102908 | 1102908 | 2021-03-09 | Crawford | Indiana | 18025 | 927 | 14 |
1106154 | 1106154 | 2021-03-10 | Crawford | Indiana | 18025 | 928 | 14 |
1109400 | 1109400 | 2021-03-11 | Crawford | Indiana | 18025 | 931 | 14 |
1112646 | 1112646 | 2021-03-12 | Crawford | Indiana | 18025 | 932 | 14 |
1115892 | 1115892 | 2021-03-13 | Crawford | Indiana | 18025 | 932 | 14 |
1119139 | 1119139 | 2021-03-14 | Crawford | Indiana | 18025 | 933 | 14 |
1122386 | 1122386 | 2021-03-15 | Crawford | Indiana | 18025 | 937 | 14 |
1125632 | 1125632 | 2021-03-16 | Crawford | Indiana | 18025 | 940 | 14 |
1128878 | 1128878 | 2021-03-17 | Crawford | Indiana | 18025 | 941 | 14 |
1132126 | 1132126 | 2021-03-18 | Crawford | Indiana | 18025 | 943 | 14 |
1135373 | 1135373 | 2021-03-19 | Crawford | Indiana | 18025 | 945 | 14 |
1138619 | 1138619 | 2021-03-20 | Crawford | Indiana | 18025 | 946 | 14 |
1141865 | 1141865 | 2021-03-21 | Crawford | Indiana | 18025 | 946 | 14 |
1145112 | 1145112 | 2021-03-22 | Crawford | Indiana | 18025 | 948 | 14 |
1148359 | 1148359 | 2021-03-23 | Crawford | Indiana | 18025 | 949 | 14 |
1151606 | 1151606 | 2021-03-24 | Crawford | Indiana | 18025 | 951 | 14 |
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);