ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Boone" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278252 | 1278252 | 2021-05-02 | Boone | Indiana | 18011 | 6664 | 105 |
1275005 | 1275005 | 2021-05-01 | Boone | Indiana | 18011 | 6657 | 105 |
1271758 | 1271758 | 2021-04-30 | Boone | Indiana | 18011 | 6647 | 105 |
1268511 | 1268511 | 2021-04-29 | Boone | Indiana | 18011 | 6639 | 105 |
1265264 | 1265264 | 2021-04-28 | Boone | Indiana | 18011 | 6632 | 105 |
1262017 | 1262017 | 2021-04-27 | Boone | Indiana | 18011 | 6626 | 104 |
1258770 | 1258770 | 2021-04-26 | Boone | Indiana | 18011 | 6623 | 104 |
1255523 | 1255523 | 2021-04-25 | Boone | Indiana | 18011 | 6617 | 104 |
1252276 | 1252276 | 2021-04-24 | Boone | Indiana | 18011 | 6615 | 104 |
1249029 | 1249029 | 2021-04-23 | Boone | Indiana | 18011 | 6608 | 104 |
1245782 | 1245782 | 2021-04-22 | Boone | Indiana | 18011 | 6603 | 104 |
1242535 | 1242535 | 2021-04-21 | Boone | Indiana | 18011 | 6587 | 104 |
1239288 | 1239288 | 2021-04-20 | Boone | Indiana | 18011 | 6581 | 104 |
1236041 | 1236041 | 2021-04-19 | Boone | Indiana | 18011 | 6575 | 104 |
1232794 | 1232794 | 2021-04-18 | Boone | Indiana | 18011 | 6571 | 104 |
1229545 | 1229545 | 2021-04-17 | Boone | Indiana | 18011 | 6560 | 104 |
1226297 | 1226297 | 2021-04-16 | Boone | Indiana | 18011 | 6543 | 104 |
1223050 | 1223050 | 2021-04-15 | Boone | Indiana | 18011 | 6543 | 104 |
1219802 | 1219802 | 2021-04-14 | Boone | Indiana | 18011 | 6536 | 104 |
1216554 | 1216554 | 2021-04-13 | Boone | Indiana | 18011 | 6529 | 103 |
1213307 | 1213307 | 2021-04-12 | Boone | Indiana | 18011 | 6513 | 103 |
1210059 | 1210059 | 2021-04-11 | Boone | Indiana | 18011 | 6500 | 103 |
1206810 | 1206810 | 2021-04-10 | Boone | Indiana | 18011 | 6492 | 103 |
1203562 | 1203562 | 2021-04-09 | Boone | Indiana | 18011 | 6482 | 103 |
1200314 | 1200314 | 2021-04-08 | Boone | Indiana | 18011 | 6468 | 103 |
1197065 | 1197065 | 2021-04-07 | Boone | Indiana | 18011 | 6449 | 103 |
1193817 | 1193817 | 2021-04-06 | Boone | Indiana | 18011 | 6437 | 103 |
1190567 | 1190567 | 2021-04-05 | Boone | Indiana | 18011 | 6433 | 103 |
1187320 | 1187320 | 2021-04-04 | Boone | Indiana | 18011 | 6423 | 103 |
1184073 | 1184073 | 2021-04-03 | Boone | Indiana | 18011 | 6413 | 103 |
1180826 | 1180826 | 2021-04-02 | Boone | Indiana | 18011 | 6399 | 103 |
1177579 | 1177579 | 2021-04-01 | Boone | Indiana | 18011 | 6391 | 103 |
1174332 | 1174332 | 2021-03-31 | Boone | Indiana | 18011 | 6385 | 103 |
1171085 | 1171085 | 2021-03-30 | Boone | Indiana | 18011 | 6382 | 102 |
1167837 | 1167837 | 2021-03-29 | Boone | Indiana | 18011 | 6379 | 102 |
1164589 | 1164589 | 2021-03-28 | Boone | Indiana | 18011 | 6370 | 102 |
1161341 | 1161341 | 2021-03-27 | Boone | Indiana | 18011 | 6354 | 102 |
1158093 | 1158093 | 2021-03-26 | Boone | Indiana | 18011 | 6347 | 102 |
1154846 | 1154846 | 2021-03-25 | Boone | Indiana | 18011 | 6334 | 101 |
1151599 | 1151599 | 2021-03-24 | Boone | Indiana | 18011 | 6330 | 101 |
1148352 | 1148352 | 2021-03-23 | Boone | Indiana | 18011 | 6323 | 100 |
1145105 | 1145105 | 2021-03-22 | Boone | Indiana | 18011 | 6315 | 100 |
1141858 | 1141858 | 2021-03-21 | Boone | Indiana | 18011 | 6313 | 100 |
1138612 | 1138612 | 2021-03-20 | Boone | Indiana | 18011 | 6305 | 100 |
1135366 | 1135366 | 2021-03-19 | Boone | Indiana | 18011 | 6295 | 100 |
1132119 | 1132119 | 2021-03-18 | Boone | Indiana | 18011 | 6288 | 100 |
1128871 | 1128871 | 2021-03-17 | Boone | Indiana | 18011 | 6278 | 100 |
1125625 | 1125625 | 2021-03-16 | Boone | Indiana | 18011 | 6271 | 99 |
1122379 | 1122379 | 2021-03-15 | Boone | Indiana | 18011 | 6267 | 98 |
1119132 | 1119132 | 2021-03-14 | Boone | Indiana | 18011 | 6266 | 98 |
1115885 | 1115885 | 2021-03-13 | Boone | Indiana | 18011 | 6261 | 98 |
1112639 | 1112639 | 2021-03-12 | Boone | Indiana | 18011 | 6259 | 97 |
1109393 | 1109393 | 2021-03-11 | Boone | Indiana | 18011 | 6246 | 96 |
1106147 | 1106147 | 2021-03-10 | Boone | Indiana | 18011 | 6240 | 96 |
1102901 | 1102901 | 2021-03-09 | Boone | Indiana | 18011 | 6219 | 96 |
1099655 | 1099655 | 2021-03-08 | Boone | Indiana | 18011 | 6215 | 96 |
1096407 | 1096407 | 2021-03-07 | Boone | Indiana | 18011 | 6206 | 96 |
1093161 | 1093161 | 2021-03-06 | Boone | Indiana | 18011 | 6186 | 96 |
1089915 | 1089915 | 2021-03-05 | Boone | Indiana | 18011 | 6139 | 96 |
1086670 | 1086670 | 2021-03-04 | Boone | Indiana | 18011 | 6129 | 94 |
1083424 | 1083424 | 2021-03-03 | Boone | Indiana | 18011 | 6123 | 94 |
1080178 | 1080178 | 2021-03-02 | Boone | Indiana | 18011 | 6120 | 93 |
1076933 | 1076933 | 2021-03-01 | Boone | Indiana | 18011 | 6110 | 93 |
1073687 | 1073687 | 2021-02-28 | Boone | Indiana | 18011 | 6102 | 93 |
1070441 | 1070441 | 2021-02-27 | Boone | Indiana | 18011 | 6092 | 93 |
1067196 | 1067196 | 2021-02-26 | Boone | Indiana | 18011 | 6088 | 93 |
1063951 | 1063951 | 2021-02-25 | Boone | Indiana | 18011 | 6073 | 93 |
1060706 | 1060706 | 2021-02-24 | Boone | Indiana | 18011 | 6061 | 93 |
1057460 | 1057460 | 2021-02-23 | Boone | Indiana | 18011 | 6053 | 93 |
1054214 | 1054214 | 2021-02-22 | Boone | Indiana | 18011 | 6049 | 93 |
1050967 | 1050967 | 2021-02-21 | Boone | Indiana | 18011 | 6041 | 93 |
1047720 | 1047720 | 2021-02-20 | Boone | Indiana | 18011 | 6034 | 93 |
1044475 | 1044475 | 2021-02-19 | Boone | Indiana | 18011 | 6025 | 93 |
1041230 | 1041230 | 2021-02-18 | Boone | Indiana | 18011 | 6014 | 93 |
1037985 | 1037985 | 2021-02-17 | Boone | Indiana | 18011 | 6005 | 93 |
1034740 | 1034740 | 2021-02-16 | Boone | Indiana | 18011 | 5997 | 93 |
1031494 | 1031494 | 2021-02-15 | Boone | Indiana | 18011 | 5989 | 92 |
1028247 | 1028247 | 2021-02-14 | Boone | Indiana | 18011 | 5980 | 92 |
1025002 | 1025002 | 2021-02-13 | Boone | Indiana | 18011 | 5975 | 92 |
1021757 | 1021757 | 2021-02-12 | Boone | Indiana | 18011 | 5966 | 92 |
1018512 | 1018512 | 2021-02-11 | Boone | Indiana | 18011 | 5946 | 91 |
1015267 | 1015267 | 2021-02-10 | Boone | Indiana | 18011 | 5912 | 91 |
1012022 | 1012022 | 2021-02-09 | Boone | Indiana | 18011 | 5895 | 91 |
1008776 | 1008776 | 2021-02-08 | Boone | Indiana | 18011 | 5874 | 90 |
1005530 | 1005530 | 2021-02-07 | Boone | Indiana | 18011 | 5856 | 89 |
1002284 | 1002284 | 2021-02-06 | Boone | Indiana | 18011 | 5842 | 88 |
999038 | 999038 | 2021-02-05 | Boone | Indiana | 18011 | 5813 | 88 |
995792 | 995792 | 2021-02-04 | Boone | Indiana | 18011 | 5800 | 88 |
992546 | 992546 | 2021-02-03 | Boone | Indiana | 18011 | 5778 | 75 |
989300 | 989300 | 2021-02-02 | Boone | Indiana | 18011 | 5767 | 74 |
986053 | 986053 | 2021-02-01 | Boone | Indiana | 18011 | 5750 | 74 |
982806 | 982806 | 2021-01-31 | Boone | Indiana | 18011 | 5731 | 73 |
979560 | 979560 | 2021-01-30 | Boone | Indiana | 18011 | 5705 | 73 |
976314 | 976314 | 2021-01-29 | Boone | Indiana | 18011 | 5687 | 73 |
973069 | 973069 | 2021-01-28 | Boone | Indiana | 18011 | 5664 | 72 |
969824 | 969824 | 2021-01-27 | Boone | Indiana | 18011 | 5618 | 72 |
966580 | 966580 | 2021-01-26 | Boone | Indiana | 18011 | 5598 | 72 |
963335 | 963335 | 2021-01-25 | Boone | Indiana | 18011 | 5583 | 72 |
960090 | 960090 | 2021-01-24 | Boone | Indiana | 18011 | 5565 | 72 |
956844 | 956844 | 2021-01-23 | Boone | Indiana | 18011 | 5530 | 72 |
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);