ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 5009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277658 | 1277658 | 2021-05-02 | Boone | Arkansas | 5009 | 3807 | 80 |
1274411 | 1274411 | 2021-05-01 | Boone | Arkansas | 5009 | 3804 | 80 |
1271164 | 1271164 | 2021-04-30 | Boone | Arkansas | 5009 | 3802 | 80 |
1267917 | 1267917 | 2021-04-29 | Boone | Arkansas | 5009 | 3801 | 80 |
1264670 | 1264670 | 2021-04-28 | Boone | Arkansas | 5009 | 3799 | 80 |
1261423 | 1261423 | 2021-04-27 | Boone | Arkansas | 5009 | 3793 | 80 |
1258176 | 1258176 | 2021-04-26 | Boone | Arkansas | 5009 | 3787 | 80 |
1254929 | 1254929 | 2021-04-25 | Boone | Arkansas | 5009 | 3786 | 80 |
1251682 | 1251682 | 2021-04-24 | Boone | Arkansas | 5009 | 3785 | 80 |
1248435 | 1248435 | 2021-04-23 | Boone | Arkansas | 5009 | 3782 | 80 |
1245188 | 1245188 | 2021-04-22 | Boone | Arkansas | 5009 | 3779 | 80 |
1241941 | 1241941 | 2021-04-21 | Boone | Arkansas | 5009 | 3779 | 79 |
1238694 | 1238694 | 2021-04-20 | Boone | Arkansas | 5009 | 3773 | 79 |
1235447 | 1235447 | 2021-04-19 | Boone | Arkansas | 5009 | 3771 | 79 |
1232200 | 1232200 | 2021-04-18 | Boone | Arkansas | 5009 | 3771 | 79 |
1228951 | 1228951 | 2021-04-17 | Boone | Arkansas | 5009 | 3768 | 79 |
1225703 | 1225703 | 2021-04-16 | Boone | Arkansas | 5009 | 3765 | 79 |
1222456 | 1222456 | 2021-04-15 | Boone | Arkansas | 5009 | 3764 | 79 |
1219208 | 1219208 | 2021-04-14 | Boone | Arkansas | 5009 | 3761 | 79 |
1215960 | 1215960 | 2021-04-13 | Boone | Arkansas | 5009 | 3760 | 79 |
1212713 | 1212713 | 2021-04-12 | Boone | Arkansas | 5009 | 3758 | 79 |
1209465 | 1209465 | 2021-04-11 | Boone | Arkansas | 5009 | 3756 | 79 |
1206216 | 1206216 | 2021-04-10 | Boone | Arkansas | 5009 | 3754 | 79 |
1202968 | 1202968 | 2021-04-09 | Boone | Arkansas | 5009 | 3750 | 79 |
1199720 | 1199720 | 2021-04-08 | Boone | Arkansas | 5009 | 3746 | 79 |
1196471 | 1196471 | 2021-04-07 | Boone | Arkansas | 5009 | 3745 | 79 |
1193223 | 1193223 | 2021-04-06 | Boone | Arkansas | 5009 | 3744 | 79 |
1189973 | 1189973 | 2021-04-05 | Boone | Arkansas | 5009 | 3744 | 79 |
1186726 | 1186726 | 2021-04-04 | Boone | Arkansas | 5009 | 3744 | 79 |
1183479 | 1183479 | 2021-04-03 | Boone | Arkansas | 5009 | 3744 | 79 |
1180232 | 1180232 | 2021-04-02 | Boone | Arkansas | 5009 | 3743 | 79 |
1176985 | 1176985 | 2021-04-01 | Boone | Arkansas | 5009 | 3742 | 79 |
1173738 | 1173738 | 2021-03-31 | Boone | Arkansas | 5009 | 3742 | 79 |
1170491 | 1170491 | 2021-03-30 | Boone | Arkansas | 5009 | 3740 | 79 |
1167243 | 1167243 | 2021-03-29 | Boone | Arkansas | 5009 | 3737 | 79 |
1163995 | 1163995 | 2021-03-28 | Boone | Arkansas | 5009 | 3735 | 79 |
1160747 | 1160747 | 2021-03-27 | Boone | Arkansas | 5009 | 3735 | 79 |
1157499 | 1157499 | 2021-03-26 | Boone | Arkansas | 5009 | 3733 | 79 |
1154252 | 1154252 | 2021-03-25 | Boone | Arkansas | 5009 | 3730 | 78 |
1151005 | 1151005 | 2021-03-24 | Boone | Arkansas | 5009 | 3723 | 78 |
1147758 | 1147758 | 2021-03-23 | Boone | Arkansas | 5009 | 3717 | 78 |
1144511 | 1144511 | 2021-03-22 | Boone | Arkansas | 5009 | 3713 | 78 |
1141264 | 1141264 | 2021-03-21 | Boone | Arkansas | 5009 | 3713 | 78 |
1138018 | 1138018 | 2021-03-20 | Boone | Arkansas | 5009 | 3711 | 78 |
1134772 | 1134772 | 2021-03-19 | Boone | Arkansas | 5009 | 3710 | 78 |
1131525 | 1131525 | 2021-03-18 | Boone | Arkansas | 5009 | 3707 | 78 |
1128277 | 1128277 | 2021-03-17 | Boone | Arkansas | 5009 | 3705 | 78 |
1125031 | 1125031 | 2021-03-16 | Boone | Arkansas | 5009 | 3702 | 78 |
1121785 | 1121785 | 2021-03-15 | Boone | Arkansas | 5009 | 3698 | 78 |
1118538 | 1118538 | 2021-03-14 | Boone | Arkansas | 5009 | 3698 | 78 |
1115291 | 1115291 | 2021-03-13 | Boone | Arkansas | 5009 | 3698 | 78 |
1112045 | 1112045 | 2021-03-12 | Boone | Arkansas | 5009 | 3686 | 77 |
1108799 | 1108799 | 2021-03-11 | Boone | Arkansas | 5009 | 3682 | 77 |
1105553 | 1105553 | 2021-03-10 | Boone | Arkansas | 5009 | 3676 | 76 |
1102307 | 1102307 | 2021-03-09 | Boone | Arkansas | 5009 | 3674 | 75 |
1099061 | 1099061 | 2021-03-08 | Boone | Arkansas | 5009 | 3672 | 75 |
1095813 | 1095813 | 2021-03-07 | Boone | Arkansas | 5009 | 3672 | 75 |
1092567 | 1092567 | 2021-03-06 | Boone | Arkansas | 5009 | 3670 | 75 |
1089321 | 1089321 | 2021-03-05 | Boone | Arkansas | 5009 | 3670 | 75 |
1086076 | 1086076 | 2021-03-04 | Boone | Arkansas | 5009 | 3667 | 73 |
1082830 | 1082830 | 2021-03-03 | Boone | Arkansas | 5009 | 3658 | 73 |
1079584 | 1079584 | 2021-03-02 | Boone | Arkansas | 5009 | 3651 | 73 |
1076339 | 1076339 | 2021-03-01 | Boone | Arkansas | 5009 | 3641 | 73 |
1073093 | 1073093 | 2021-02-28 | Boone | Arkansas | 5009 | 3638 | 73 |
1069847 | 1069847 | 2021-02-27 | Boone | Arkansas | 5009 | 3636 | 79 |
1066602 | 1066602 | 2021-02-26 | Boone | Arkansas | 5009 | 3630 | 79 |
1063357 | 1063357 | 2021-02-25 | Boone | Arkansas | 5009 | 3620 | 79 |
1060112 | 1060112 | 2021-02-24 | Boone | Arkansas | 5009 | 3612 | 78 |
1056866 | 1056866 | 2021-02-23 | Boone | Arkansas | 5009 | 3591 | 78 |
1053620 | 1053620 | 2021-02-22 | Boone | Arkansas | 5009 | 3584 | 78 |
1050373 | 1050373 | 2021-02-21 | Boone | Arkansas | 5009 | 3582 | 78 |
1047126 | 1047126 | 2021-02-20 | Boone | Arkansas | 5009 | 3580 | 78 |
1043881 | 1043881 | 2021-02-19 | Boone | Arkansas | 5009 | 3576 | 78 |
1040636 | 1040636 | 2021-02-18 | Boone | Arkansas | 5009 | 3574 | 77 |
1037391 | 1037391 | 2021-02-17 | Boone | Arkansas | 5009 | 3567 | 77 |
1034146 | 1034146 | 2021-02-16 | Boone | Arkansas | 5009 | 3559 | 76 |
1030900 | 1030900 | 2021-02-15 | Boone | Arkansas | 5009 | 3555 | 76 |
1027653 | 1027653 | 2021-02-14 | Boone | Arkansas | 5009 | 3552 | 76 |
1024408 | 1024408 | 2021-02-13 | Boone | Arkansas | 5009 | 3548 | 76 |
1021163 | 1021163 | 2021-02-12 | Boone | Arkansas | 5009 | 3533 | 76 |
1017918 | 1017918 | 2021-02-11 | Boone | Arkansas | 5009 | 3526 | 76 |
1014673 | 1014673 | 2021-02-10 | Boone | Arkansas | 5009 | 3516 | 76 |
1011428 | 1011428 | 2021-02-09 | Boone | Arkansas | 5009 | 3505 | 76 |
1008182 | 1008182 | 2021-02-08 | Boone | Arkansas | 5009 | 3486 | 76 |
1004936 | 1004936 | 2021-02-07 | Boone | Arkansas | 5009 | 3471 | 76 |
1001690 | 1001690 | 2021-02-06 | Boone | Arkansas | 5009 | 3468 | 76 |
998444 | 998444 | 2021-02-05 | Boone | Arkansas | 5009 | 3448 | 75 |
995198 | 995198 | 2021-02-04 | Boone | Arkansas | 5009 | 3425 | 75 |
991952 | 991952 | 2021-02-03 | Boone | Arkansas | 5009 | 3400 | 75 |
988706 | 988706 | 2021-02-02 | Boone | Arkansas | 5009 | 3364 | 74 |
985459 | 985459 | 2021-02-01 | Boone | Arkansas | 5009 | 3346 | 74 |
982212 | 982212 | 2021-01-31 | Boone | Arkansas | 5009 | 3334 | 74 |
978966 | 978966 | 2021-01-30 | Boone | Arkansas | 5009 | 3329 | 74 |
975721 | 975721 | 2021-01-29 | Boone | Arkansas | 5009 | 3305 | 74 |
972476 | 972476 | 2021-01-28 | Boone | Arkansas | 5009 | 3274 | 74 |
969231 | 969231 | 2021-01-27 | Boone | Arkansas | 5009 | 3251 | 74 |
965987 | 965987 | 2021-01-26 | Boone | Arkansas | 5009 | 3215 | 74 |
962742 | 962742 | 2021-01-25 | Boone | Arkansas | 5009 | 3169 | 74 |
959497 | 959497 | 2021-01-24 | Boone | Arkansas | 5009 | 3162 | 74 |
956251 | 956251 | 2021-01-23 | Boone | Arkansas | 5009 | 3155 | 74 |
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);