ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Saline", fips = 5125 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277715 | 1277715 | 2021-05-02 | Saline | Arkansas | 5125 | 11873 | 166 |
1274468 | 1274468 | 2021-05-01 | Saline | Arkansas | 5125 | 11867 | 166 |
1271221 | 1271221 | 2021-04-30 | Saline | Arkansas | 5125 | 11858 | 166 |
1267974 | 1267974 | 2021-04-29 | Saline | Arkansas | 5125 | 11848 | 166 |
1264727 | 1264727 | 2021-04-28 | Saline | Arkansas | 5125 | 11842 | 166 |
1261480 | 1261480 | 2021-04-27 | Saline | Arkansas | 5125 | 11834 | 166 |
1258233 | 1258233 | 2021-04-26 | Saline | Arkansas | 5125 | 11826 | 166 |
1254986 | 1254986 | 2021-04-25 | Saline | Arkansas | 5125 | 11824 | 166 |
1251739 | 1251739 | 2021-04-24 | Saline | Arkansas | 5125 | 11823 | 166 |
1248492 | 1248492 | 2021-04-23 | Saline | Arkansas | 5125 | 11820 | 166 |
1245245 | 1245245 | 2021-04-22 | Saline | Arkansas | 5125 | 11814 | 166 |
1241998 | 1241998 | 2021-04-21 | Saline | Arkansas | 5125 | 11809 | 166 |
1238751 | 1238751 | 2021-04-20 | Saline | Arkansas | 5125 | 11802 | 166 |
1235504 | 1235504 | 2021-04-19 | Saline | Arkansas | 5125 | 11790 | 166 |
1232257 | 1232257 | 2021-04-18 | Saline | Arkansas | 5125 | 11788 | 166 |
1229008 | 1229008 | 2021-04-17 | Saline | Arkansas | 5125 | 11785 | 166 |
1225760 | 1225760 | 2021-04-16 | Saline | Arkansas | 5125 | 11781 | 166 |
1222513 | 1222513 | 2021-04-15 | Saline | Arkansas | 5125 | 11774 | 166 |
1219265 | 1219265 | 2021-04-14 | Saline | Arkansas | 5125 | 11769 | 166 |
1216017 | 1216017 | 2021-04-13 | Saline | Arkansas | 5125 | 11762 | 166 |
1212770 | 1212770 | 2021-04-12 | Saline | Arkansas | 5125 | 11758 | 166 |
1209522 | 1209522 | 2021-04-11 | Saline | Arkansas | 5125 | 11757 | 166 |
1206273 | 1206273 | 2021-04-10 | Saline | Arkansas | 5125 | 11755 | 166 |
1203025 | 1203025 | 2021-04-09 | Saline | Arkansas | 5125 | 11752 | 166 |
1199777 | 1199777 | 2021-04-08 | Saline | Arkansas | 5125 | 11753 | 166 |
1196528 | 1196528 | 2021-04-07 | Saline | Arkansas | 5125 | 11744 | 166 |
1193280 | 1193280 | 2021-04-06 | Saline | Arkansas | 5125 | 11744 | 166 |
1190030 | 1190030 | 2021-04-05 | Saline | Arkansas | 5125 | 11743 | 166 |
1186783 | 1186783 | 2021-04-04 | Saline | Arkansas | 5125 | 11743 | 166 |
1183536 | 1183536 | 2021-04-03 | Saline | Arkansas | 5125 | 11740 | 166 |
1180289 | 1180289 | 2021-04-02 | Saline | Arkansas | 5125 | 11736 | 165 |
1177042 | 1177042 | 2021-04-01 | Saline | Arkansas | 5125 | 11734 | 165 |
1173795 | 1173795 | 2021-03-31 | Saline | Arkansas | 5125 | 11724 | 165 |
1170548 | 1170548 | 2021-03-30 | Saline | Arkansas | 5125 | 11716 | 164 |
1167300 | 1167300 | 2021-03-29 | Saline | Arkansas | 5125 | 11707 | 163 |
1164052 | 1164052 | 2021-03-28 | Saline | Arkansas | 5125 | 11703 | 162 |
1160804 | 1160804 | 2021-03-27 | Saline | Arkansas | 5125 | 11702 | 162 |
1157556 | 1157556 | 2021-03-26 | Saline | Arkansas | 5125 | 11693 | 162 |
1154309 | 1154309 | 2021-03-25 | Saline | Arkansas | 5125 | 11690 | 162 |
1151062 | 1151062 | 2021-03-24 | Saline | Arkansas | 5125 | 11685 | 162 |
1147815 | 1147815 | 2021-03-23 | Saline | Arkansas | 5125 | 11677 | 162 |
1144568 | 1144568 | 2021-03-22 | Saline | Arkansas | 5125 | 11664 | 162 |
1141321 | 1141321 | 2021-03-21 | Saline | Arkansas | 5125 | 11661 | 162 |
1138075 | 1138075 | 2021-03-20 | Saline | Arkansas | 5125 | 11656 | 162 |
1134829 | 1134829 | 2021-03-19 | Saline | Arkansas | 5125 | 11644 | 162 |
1131582 | 1131582 | 2021-03-18 | Saline | Arkansas | 5125 | 11638 | 162 |
1128334 | 1128334 | 2021-03-17 | Saline | Arkansas | 5125 | 11634 | 162 |
1125088 | 1125088 | 2021-03-16 | Saline | Arkansas | 5125 | 11623 | 162 |
1121842 | 1121842 | 2021-03-15 | Saline | Arkansas | 5125 | 11594 | 161 |
1118595 | 1118595 | 2021-03-14 | Saline | Arkansas | 5125 | 11582 | 161 |
1115348 | 1115348 | 2021-03-13 | Saline | Arkansas | 5125 | 11576 | 161 |
1112102 | 1112102 | 2021-03-12 | Saline | Arkansas | 5125 | 11569 | 161 |
1108856 | 1108856 | 2021-03-11 | Saline | Arkansas | 5125 | 11555 | 161 |
1105610 | 1105610 | 2021-03-10 | Saline | Arkansas | 5125 | 11540 | 160 |
1102364 | 1102364 | 2021-03-09 | Saline | Arkansas | 5125 | 11532 | 160 |
1099118 | 1099118 | 2021-03-08 | Saline | Arkansas | 5125 | 11517 | 161 |
1095870 | 1095870 | 2021-03-07 | Saline | Arkansas | 5125 | 11512 | 158 |
1092624 | 1092624 | 2021-03-06 | Saline | Arkansas | 5125 | 11509 | 157 |
1089378 | 1089378 | 2021-03-05 | Saline | Arkansas | 5125 | 11495 | 155 |
1086133 | 1086133 | 2021-03-04 | Saline | Arkansas | 5125 | 11466 | 155 |
1082887 | 1082887 | 2021-03-03 | Saline | Arkansas | 5125 | 11459 | 154 |
1079641 | 1079641 | 2021-03-02 | Saline | Arkansas | 5125 | 11441 | 154 |
1076396 | 1076396 | 2021-03-01 | Saline | Arkansas | 5125 | 11430 | 154 |
1073150 | 1073150 | 2021-02-28 | Saline | Arkansas | 5125 | 11427 | 154 |
1069904 | 1069904 | 2021-02-27 | Saline | Arkansas | 5125 | 11386 | 164 |
1066659 | 1066659 | 2021-02-26 | Saline | Arkansas | 5125 | 11373 | 164 |
1063414 | 1063414 | 2021-02-25 | Saline | Arkansas | 5125 | 11359 | 163 |
1060169 | 1060169 | 2021-02-24 | Saline | Arkansas | 5125 | 11339 | 163 |
1056923 | 1056923 | 2021-02-23 | Saline | Arkansas | 5125 | 11290 | 163 |
1053677 | 1053677 | 2021-02-22 | Saline | Arkansas | 5125 | 11261 | 163 |
1050430 | 1050430 | 2021-02-21 | Saline | Arkansas | 5125 | 11254 | 163 |
1047183 | 1047183 | 2021-02-20 | Saline | Arkansas | 5125 | 11247 | 162 |
1043938 | 1043938 | 2021-02-19 | Saline | Arkansas | 5125 | 11232 | 162 |
1040693 | 1040693 | 2021-02-18 | Saline | Arkansas | 5125 | 11228 | 162 |
1037448 | 1037448 | 2021-02-17 | Saline | Arkansas | 5125 | 11217 | 162 |
1034203 | 1034203 | 2021-02-16 | Saline | Arkansas | 5125 | 11194 | 161 |
1030957 | 1030957 | 2021-02-15 | Saline | Arkansas | 5125 | 11191 | 161 |
1027710 | 1027710 | 2021-02-14 | Saline | Arkansas | 5125 | 11182 | 159 |
1024465 | 1024465 | 2021-02-13 | Saline | Arkansas | 5125 | 11166 | 159 |
1021220 | 1021220 | 2021-02-12 | Saline | Arkansas | 5125 | 11123 | 159 |
1017975 | 1017975 | 2021-02-11 | Saline | Arkansas | 5125 | 11097 | 159 |
1014730 | 1014730 | 2021-02-10 | Saline | Arkansas | 5125 | 11039 | 157 |
1011485 | 1011485 | 2021-02-09 | Saline | Arkansas | 5125 | 10971 | 156 |
1008239 | 1008239 | 2021-02-08 | Saline | Arkansas | 5125 | 10897 | 155 |
1004993 | 1004993 | 2021-02-07 | Saline | Arkansas | 5125 | 10878 | 153 |
1001747 | 1001747 | 2021-02-06 | Saline | Arkansas | 5125 | 10851 | 153 |
998501 | 998501 | 2021-02-05 | Saline | Arkansas | 5125 | 10788 | 153 |
995255 | 995255 | 2021-02-04 | Saline | Arkansas | 5125 | 10702 | 153 |
992009 | 992009 | 2021-02-03 | Saline | Arkansas | 5125 | 10625 | 152 |
988763 | 988763 | 2021-02-02 | Saline | Arkansas | 5125 | 10519 | 150 |
985516 | 985516 | 2021-02-01 | Saline | Arkansas | 5125 | 10448 | 149 |
982269 | 982269 | 2021-01-31 | Saline | Arkansas | 5125 | 10403 | 148 |
979023 | 979023 | 2021-01-30 | Saline | Arkansas | 5125 | 10370 | 147 |
975778 | 975778 | 2021-01-29 | Saline | Arkansas | 5125 | 10280 | 146 |
972533 | 972533 | 2021-01-28 | Saline | Arkansas | 5125 | 10199 | 146 |
969288 | 969288 | 2021-01-27 | Saline | Arkansas | 5125 | 10112 | 145 |
966044 | 966044 | 2021-01-26 | Saline | Arkansas | 5125 | 10036 | 143 |
962799 | 962799 | 2021-01-25 | Saline | Arkansas | 5125 | 9927 | 140 |
959554 | 959554 | 2021-01-24 | Saline | Arkansas | 5125 | 9906 | 140 |
956308 | 956308 | 2021-01-23 | Saline | Arkansas | 5125 | 9860 | 139 |
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);