ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 18035 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278264 | 1278264 | 2021-05-02 | Delaware | Indiana | 18035 | 10563 | 192 |
1275017 | 1275017 | 2021-05-01 | Delaware | Indiana | 18035 | 10545 | 192 |
1271770 | 1271770 | 2021-04-30 | Delaware | Indiana | 18035 | 10523 | 192 |
1268523 | 1268523 | 2021-04-29 | Delaware | Indiana | 18035 | 10512 | 192 |
1265276 | 1265276 | 2021-04-28 | Delaware | Indiana | 18035 | 10488 | 192 |
1262029 | 1262029 | 2021-04-27 | Delaware | Indiana | 18035 | 10467 | 191 |
1258782 | 1258782 | 2021-04-26 | Delaware | Indiana | 18035 | 10457 | 191 |
1255535 | 1255535 | 2021-04-25 | Delaware | Indiana | 18035 | 10441 | 191 |
1252288 | 1252288 | 2021-04-24 | Delaware | Indiana | 18035 | 10433 | 191 |
1249041 | 1249041 | 2021-04-23 | Delaware | Indiana | 18035 | 10417 | 191 |
1245794 | 1245794 | 2021-04-22 | Delaware | Indiana | 18035 | 10405 | 191 |
1242547 | 1242547 | 2021-04-21 | Delaware | Indiana | 18035 | 10397 | 191 |
1239300 | 1239300 | 2021-04-20 | Delaware | Indiana | 18035 | 10389 | 191 |
1236053 | 1236053 | 2021-04-19 | Delaware | Indiana | 18035 | 10381 | 191 |
1232806 | 1232806 | 2021-04-18 | Delaware | Indiana | 18035 | 10371 | 191 |
1229557 | 1229557 | 2021-04-17 | Delaware | Indiana | 18035 | 10356 | 191 |
1226309 | 1226309 | 2021-04-16 | Delaware | Indiana | 18035 | 10340 | 191 |
1223062 | 1223062 | 2021-04-15 | Delaware | Indiana | 18035 | 10326 | 190 |
1219814 | 1219814 | 2021-04-14 | Delaware | Indiana | 18035 | 10302 | 190 |
1216566 | 1216566 | 2021-04-13 | Delaware | Indiana | 18035 | 10285 | 190 |
1213319 | 1213319 | 2021-04-12 | Delaware | Indiana | 18035 | 10277 | 189 |
1210071 | 1210071 | 2021-04-11 | Delaware | Indiana | 18035 | 10265 | 189 |
1206822 | 1206822 | 2021-04-10 | Delaware | Indiana | 18035 | 10255 | 188 |
1203574 | 1203574 | 2021-04-09 | Delaware | Indiana | 18035 | 10234 | 188 |
1200326 | 1200326 | 2021-04-08 | Delaware | Indiana | 18035 | 10218 | 188 |
1197077 | 1197077 | 2021-04-07 | Delaware | Indiana | 18035 | 10199 | 188 |
1193829 | 1193829 | 2021-04-06 | Delaware | Indiana | 18035 | 10191 | 188 |
1190579 | 1190579 | 2021-04-05 | Delaware | Indiana | 18035 | 10188 | 188 |
1187332 | 1187332 | 2021-04-04 | Delaware | Indiana | 18035 | 10178 | 188 |
1184085 | 1184085 | 2021-04-03 | Delaware | Indiana | 18035 | 10170 | 188 |
1180838 | 1180838 | 2021-04-02 | Delaware | Indiana | 18035 | 10165 | 188 |
1177591 | 1177591 | 2021-04-01 | Delaware | Indiana | 18035 | 10152 | 188 |
1174344 | 1174344 | 2021-03-31 | Delaware | Indiana | 18035 | 10126 | 188 |
1171097 | 1171097 | 2021-03-30 | Delaware | Indiana | 18035 | 10119 | 188 |
1167849 | 1167849 | 2021-03-29 | Delaware | Indiana | 18035 | 10110 | 188 |
1164601 | 1164601 | 2021-03-28 | Delaware | Indiana | 18035 | 10103 | 188 |
1161353 | 1161353 | 2021-03-27 | Delaware | Indiana | 18035 | 10095 | 188 |
1158105 | 1158105 | 2021-03-26 | Delaware | Indiana | 18035 | 10081 | 188 |
1154858 | 1154858 | 2021-03-25 | Delaware | Indiana | 18035 | 10070 | 188 |
1151611 | 1151611 | 2021-03-24 | Delaware | Indiana | 18035 | 10055 | 188 |
1148364 | 1148364 | 2021-03-23 | Delaware | Indiana | 18035 | 10051 | 188 |
1145117 | 1145117 | 2021-03-22 | Delaware | Indiana | 18035 | 10044 | 188 |
1141870 | 1141870 | 2021-03-21 | Delaware | Indiana | 18035 | 10035 | 188 |
1138624 | 1138624 | 2021-03-20 | Delaware | Indiana | 18035 | 10031 | 188 |
1135378 | 1135378 | 2021-03-19 | Delaware | Indiana | 18035 | 10023 | 188 |
1132131 | 1132131 | 2021-03-18 | Delaware | Indiana | 18035 | 10015 | 187 |
1128883 | 1128883 | 2021-03-17 | Delaware | Indiana | 18035 | 10007 | 187 |
1125637 | 1125637 | 2021-03-16 | Delaware | Indiana | 18035 | 10002 | 187 |
1122391 | 1122391 | 2021-03-15 | Delaware | Indiana | 18035 | 9998 | 187 |
1119144 | 1119144 | 2021-03-14 | Delaware | Indiana | 18035 | 9989 | 187 |
1115897 | 1115897 | 2021-03-13 | Delaware | Indiana | 18035 | 9978 | 187 |
1112651 | 1112651 | 2021-03-12 | Delaware | Indiana | 18035 | 9961 | 187 |
1109405 | 1109405 | 2021-03-11 | Delaware | Indiana | 18035 | 9953 | 186 |
1106159 | 1106159 | 2021-03-10 | Delaware | Indiana | 18035 | 9945 | 186 |
1102913 | 1102913 | 2021-03-09 | Delaware | Indiana | 18035 | 9931 | 185 |
1099667 | 1099667 | 2021-03-08 | Delaware | Indiana | 18035 | 9917 | 185 |
1096419 | 1096419 | 2021-03-07 | Delaware | Indiana | 18035 | 9913 | 185 |
1093173 | 1093173 | 2021-03-06 | Delaware | Indiana | 18035 | 9905 | 185 |
1089927 | 1089927 | 2021-03-05 | Delaware | Indiana | 18035 | 9893 | 185 |
1086682 | 1086682 | 2021-03-04 | Delaware | Indiana | 18035 | 9884 | 185 |
1083436 | 1083436 | 2021-03-03 | Delaware | Indiana | 18035 | 9868 | 185 |
1080190 | 1080190 | 2021-03-02 | Delaware | Indiana | 18035 | 9856 | 185 |
1076945 | 1076945 | 2021-03-01 | Delaware | Indiana | 18035 | 9852 | 185 |
1073699 | 1073699 | 2021-02-28 | Delaware | Indiana | 18035 | 9850 | 185 |
1070453 | 1070453 | 2021-02-27 | Delaware | Indiana | 18035 | 9844 | 185 |
1067208 | 1067208 | 2021-02-26 | Delaware | Indiana | 18035 | 9838 | 185 |
1063963 | 1063963 | 2021-02-25 | Delaware | Indiana | 18035 | 9828 | 183 |
1060718 | 1060718 | 2021-02-24 | Delaware | Indiana | 18035 | 9813 | 183 |
1057472 | 1057472 | 2021-02-23 | Delaware | Indiana | 18035 | 9801 | 183 |
1054226 | 1054226 | 2021-02-22 | Delaware | Indiana | 18035 | 9798 | 183 |
1050979 | 1050979 | 2021-02-21 | Delaware | Indiana | 18035 | 9794 | 183 |
1047732 | 1047732 | 2021-02-20 | Delaware | Indiana | 18035 | 9782 | 183 |
1044487 | 1044487 | 2021-02-19 | Delaware | Indiana | 18035 | 9768 | 183 |
1041242 | 1041242 | 2021-02-18 | Delaware | Indiana | 18035 | 9762 | 181 |
1037997 | 1037997 | 2021-02-17 | Delaware | Indiana | 18035 | 9755 | 181 |
1034752 | 1034752 | 2021-02-16 | Delaware | Indiana | 18035 | 9752 | 181 |
1031506 | 1031506 | 2021-02-15 | Delaware | Indiana | 18035 | 9730 | 180 |
1028259 | 1028259 | 2021-02-14 | Delaware | Indiana | 18035 | 9724 | 180 |
1025014 | 1025014 | 2021-02-13 | Delaware | Indiana | 18035 | 9710 | 179 |
1021769 | 1021769 | 2021-02-12 | Delaware | Indiana | 18035 | 9703 | 179 |
1018524 | 1018524 | 2021-02-11 | Delaware | Indiana | 18035 | 9685 | 175 |
1015279 | 1015279 | 2021-02-10 | Delaware | Indiana | 18035 | 9641 | 175 |
1012034 | 1012034 | 2021-02-09 | Delaware | Indiana | 18035 | 9618 | 175 |
1008788 | 1008788 | 2021-02-08 | Delaware | Indiana | 18035 | 9607 | 174 |
1005542 | 1005542 | 2021-02-07 | Delaware | Indiana | 18035 | 9595 | 171 |
1002296 | 1002296 | 2021-02-06 | Delaware | Indiana | 18035 | 9576 | 171 |
999050 | 999050 | 2021-02-05 | Delaware | Indiana | 18035 | 9526 | 169 |
995804 | 995804 | 2021-02-04 | Delaware | Indiana | 18035 | 9515 | 167 |
992558 | 992558 | 2021-02-03 | Delaware | Indiana | 18035 | 9488 | 141 |
989312 | 989312 | 2021-02-02 | Delaware | Indiana | 18035 | 9476 | 140 |
986065 | 986065 | 2021-02-01 | Delaware | Indiana | 18035 | 9441 | 140 |
982818 | 982818 | 2021-01-31 | Delaware | Indiana | 18035 | 9407 | 140 |
979572 | 979572 | 2021-01-30 | Delaware | Indiana | 18035 | 9360 | 140 |
976326 | 976326 | 2021-01-29 | Delaware | Indiana | 18035 | 9328 | 140 |
973081 | 973081 | 2021-01-28 | Delaware | Indiana | 18035 | 9296 | 140 |
969836 | 969836 | 2021-01-27 | Delaware | Indiana | 18035 | 9236 | 140 |
966592 | 966592 | 2021-01-26 | Delaware | Indiana | 18035 | 9205 | 140 |
963347 | 963347 | 2021-01-25 | Delaware | Indiana | 18035 | 9182 | 138 |
960102 | 960102 | 2021-01-24 | Delaware | Indiana | 18035 | 9164 | 138 |
956856 | 956856 | 2021-01-23 | Delaware | Indiana | 18035 | 9128 | 138 |
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);