ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Wichita" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280409 | 1280409 | 2021-05-02 | Wichita | Texas | 48485 | 14971 | 375 |
1277162 | 1277162 | 2021-05-01 | Wichita | Texas | 48485 | 14971 | 375 |
1273915 | 1273915 | 2021-04-30 | Wichita | Texas | 48485 | 14971 | 375 |
1270668 | 1270668 | 2021-04-29 | Wichita | Texas | 48485 | 14953 | 375 |
1267421 | 1267421 | 2021-04-28 | Wichita | Texas | 48485 | 14953 | 375 |
1264174 | 1264174 | 2021-04-27 | Wichita | Texas | 48485 | 14944 | 375 |
1260927 | 1260927 | 2021-04-26 | Wichita | Texas | 48485 | 14944 | 374 |
1257680 | 1257680 | 2021-04-25 | Wichita | Texas | 48485 | 14930 | 374 |
1254433 | 1254433 | 2021-04-24 | Wichita | Texas | 48485 | 14930 | 374 |
1251186 | 1251186 | 2021-04-23 | Wichita | Texas | 48485 | 14930 | 374 |
1247939 | 1247939 | 2021-04-22 | Wichita | Texas | 48485 | 14916 | 374 |
1244692 | 1244692 | 2021-04-21 | Wichita | Texas | 48485 | 14916 | 374 |
1241445 | 1241445 | 2021-04-20 | Wichita | Texas | 48485 | 14909 | 374 |
1238198 | 1238198 | 2021-04-19 | Wichita | Texas | 48485 | 14909 | 374 |
1234951 | 1234951 | 2021-04-18 | Wichita | Texas | 48485 | 14899 | 374 |
1231703 | 1231703 | 2021-04-17 | Wichita | Texas | 48485 | 14899 | 374 |
1228455 | 1228455 | 2021-04-16 | Wichita | Texas | 48485 | 14899 | 374 |
1225207 | 1225207 | 2021-04-15 | Wichita | Texas | 48485 | 14889 | 374 |
1221960 | 1221960 | 2021-04-14 | Wichita | Texas | 48485 | 14889 | 373 |
1218712 | 1218712 | 2021-04-13 | Wichita | Texas | 48485 | 14875 | 373 |
1215464 | 1215464 | 2021-04-12 | Wichita | Texas | 48485 | 14875 | 373 |
1212217 | 1212217 | 2021-04-11 | Wichita | Texas | 48485 | 14868 | 373 |
1208968 | 1208968 | 2021-04-10 | Wichita | Texas | 48485 | 14868 | 373 |
1205720 | 1205720 | 2021-04-09 | Wichita | Texas | 48485 | 14868 | 373 |
1202472 | 1202472 | 2021-04-08 | Wichita | Texas | 48485 | 14857 | 373 |
1199223 | 1199223 | 2021-04-07 | Wichita | Texas | 48485 | 14857 | 373 |
1195974 | 1195974 | 2021-04-06 | Wichita | Texas | 48485 | 14845 | 369 |
1192726 | 1192726 | 2021-04-05 | Wichita | Texas | 48485 | 14845 | 369 |
1189477 | 1189477 | 2021-04-04 | Wichita | Texas | 48485 | 14840 | 369 |
1186230 | 1186230 | 2021-04-03 | Wichita | Texas | 48485 | 14840 | 369 |
1182983 | 1182983 | 2021-04-02 | Wichita | Texas | 48485 | 14840 | 369 |
1179736 | 1179736 | 2021-04-01 | Wichita | Texas | 48485 | 14835 | 368 |
1176489 | 1176489 | 2021-03-31 | Wichita | Texas | 48485 | 14835 | 368 |
1173242 | 1173242 | 2021-03-30 | Wichita | Texas | 48485 | 14822 | 368 |
1169995 | 1169995 | 2021-03-29 | Wichita | Texas | 48485 | 14822 | 368 |
1166747 | 1166747 | 2021-03-28 | Wichita | Texas | 48485 | 14808 | 368 |
1163499 | 1163499 | 2021-03-27 | Wichita | Texas | 48485 | 14808 | 368 |
1160250 | 1160250 | 2021-03-26 | Wichita | Texas | 48485 | 14808 | 368 |
1157003 | 1157003 | 2021-03-25 | Wichita | Texas | 48485 | 14801 | 368 |
1153756 | 1153756 | 2021-03-24 | Wichita | Texas | 48485 | 14793 | 369 |
1150509 | 1150509 | 2021-03-23 | Wichita | Texas | 48485 | 14773 | 368 |
1147262 | 1147262 | 2021-03-22 | Wichita | Texas | 48485 | 14756 | 367 |
1144015 | 1144015 | 2021-03-21 | Wichita | Texas | 48485 | 14742 | 367 |
1140768 | 1140768 | 2021-03-20 | Wichita | Texas | 48485 | 14742 | 367 |
1137522 | 1137522 | 2021-03-19 | Wichita | Texas | 48485 | 14742 | 367 |
1134276 | 1134276 | 2021-03-18 | Wichita | Texas | 48485 | 14735 | 367 |
1131028 | 1131028 | 2021-03-17 | Wichita | Texas | 48485 | 14728 | 366 |
1127781 | 1127781 | 2021-03-16 | Wichita | Texas | 48485 | 14718 | 366 |
1124535 | 1124535 | 2021-03-15 | Wichita | Texas | 48485 | 14713 | 364 |
1121289 | 1121289 | 2021-03-14 | Wichita | Texas | 48485 | 14705 | 364 |
1118042 | 1118042 | 2021-03-13 | Wichita | Texas | 48485 | 14705 | 364 |
1114795 | 1114795 | 2021-03-12 | Wichita | Texas | 48485 | 14705 | 364 |
1111549 | 1111549 | 2021-03-11 | Wichita | Texas | 48485 | 14701 | 361 |
1108303 | 1108303 | 2021-03-10 | Wichita | Texas | 48485 | 14691 | 360 |
1105057 | 1105057 | 2021-03-09 | Wichita | Texas | 48485 | 14673 | 359 |
1101811 | 1101811 | 2021-03-08 | Wichita | Texas | 48485 | 14655 | 359 |
1098565 | 1098565 | 2021-03-07 | Wichita | Texas | 48485 | 14634 | 359 |
1095317 | 1095317 | 2021-03-06 | Wichita | Texas | 48485 | 14634 | 359 |
1092071 | 1092071 | 2021-03-05 | Wichita | Texas | 48485 | 14634 | 356 |
1088825 | 1088825 | 2021-03-04 | Wichita | Texas | 48485 | 14632 | 353 |
1085580 | 1085580 | 2021-03-03 | Wichita | Texas | 48485 | 14615 | 352 |
1082334 | 1082334 | 2021-03-02 | Wichita | Texas | 48485 | 14607 | 351 |
1079088 | 1079088 | 2021-03-01 | Wichita | Texas | 48485 | 14586 | 346 |
1075843 | 1075843 | 2021-02-28 | Wichita | Texas | 48485 | 14566 | 346 |
1072597 | 1072597 | 2021-02-27 | Wichita | Texas | 48485 | 14566 | 345 |
1069351 | 1069351 | 2021-02-26 | Wichita | Texas | 48485 | 14566 | 344 |
1066106 | 1066106 | 2021-02-25 | Wichita | Texas | 48485 | 14555 | 343 |
1062861 | 1062861 | 2021-02-24 | Wichita | Texas | 48485 | 14541 | 341 |
1059616 | 1059616 | 2021-02-23 | Wichita | Texas | 48485 | 14509 | 336 |
1056370 | 1056370 | 2021-02-22 | Wichita | Texas | 48485 | 14469 | 334 |
1053124 | 1053124 | 2021-02-21 | Wichita | Texas | 48485 | 14358 | 333 |
1049877 | 1049877 | 2021-02-20 | Wichita | Texas | 48485 | 14358 | 332 |
1046630 | 1046630 | 2021-02-19 | Wichita | Texas | 48485 | 14358 | 330 |
1043385 | 1043385 | 2021-02-18 | Wichita | Texas | 48485 | 14358 | 330 |
1040140 | 1040140 | 2021-02-17 | Wichita | Texas | 48485 | 14358 | 330 |
1036895 | 1036895 | 2021-02-16 | Wichita | Texas | 48485 | 14358 | 328 |
1033650 | 1033650 | 2021-02-15 | Wichita | Texas | 48485 | 14358 | 328 |
1030404 | 1030404 | 2021-02-14 | Wichita | Texas | 48485 | 14358 | 328 |
1027157 | 1027157 | 2021-02-13 | Wichita | Texas | 48485 | 14358 | 327 |
1023912 | 1023912 | 2021-02-12 | Wichita | Texas | 48485 | 14358 | 326 |
1020667 | 1020667 | 2021-02-11 | Wichita | Texas | 48485 | 14338 | 322 |
1017422 | 1017422 | 2021-02-10 | Wichita | Texas | 48485 | 14301 | 320 |
1014177 | 1014177 | 2021-02-09 | Wichita | Texas | 48485 | 14269 | 317 |
1010932 | 1010932 | 2021-02-08 | Wichita | Texas | 48485 | 14226 | 315 |
1007686 | 1007686 | 2021-02-07 | Wichita | Texas | 48485 | 14175 | 315 |
1004440 | 1004440 | 2021-02-06 | Wichita | Texas | 48485 | 14175 | 315 |
1001194 | 1001194 | 2021-02-05 | Wichita | Texas | 48485 | 14175 | 315 |
997948 | 997948 | 2021-02-04 | Wichita | Texas | 48485 | 14133 | 315 |
994702 | 994702 | 2021-02-03 | Wichita | Texas | 48485 | 14077 | 301 |
991456 | 991456 | 2021-02-02 | Wichita | Texas | 48485 | 14037 | 297 |
988210 | 988210 | 2021-02-01 | Wichita | Texas | 48485 | 13973 | 295 |
984963 | 984963 | 2021-01-31 | Wichita | Texas | 48485 | 13883 | 295 |
981716 | 981716 | 2021-01-30 | Wichita | Texas | 48485 | 13883 | 295 |
978470 | 978470 | 2021-01-29 | Wichita | Texas | 48485 | 13883 | 292 |
975225 | 975225 | 2021-01-28 | Wichita | Texas | 48485 | 13844 | 291 |
971980 | 971980 | 2021-01-27 | Wichita | Texas | 48485 | 13804 | 289 |
968735 | 968735 | 2021-01-26 | Wichita | Texas | 48485 | 13731 | 288 |
965491 | 965491 | 2021-01-25 | Wichita | Texas | 48485 | 13687 | 283 |
962246 | 962246 | 2021-01-24 | Wichita | Texas | 48485 | 13585 | 283 |
959001 | 959001 | 2021-01-23 | Wichita | Texas | 48485 | 13585 | 283 |
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);