ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Bell" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280180 | 1280180 | 2021-05-02 | Bell | Texas | 48027 | 22311 | 429 |
1276933 | 1276933 | 2021-05-01 | Bell | Texas | 48027 | 22311 | 429 |
1273686 | 1273686 | 2021-04-30 | Bell | Texas | 48027 | 22311 | 429 |
1270439 | 1270439 | 2021-04-29 | Bell | Texas | 48027 | 22272 | 429 |
1267192 | 1267192 | 2021-04-28 | Bell | Texas | 48027 | 22255 | 428 |
1263945 | 1263945 | 2021-04-27 | Bell | Texas | 48027 | 22233 | 426 |
1260698 | 1260698 | 2021-04-26 | Bell | Texas | 48027 | 22169 | 425 |
1257451 | 1257451 | 2021-04-25 | Bell | Texas | 48027 | 22169 | 424 |
1254204 | 1254204 | 2021-04-24 | Bell | Texas | 48027 | 22169 | 424 |
1250957 | 1250957 | 2021-04-23 | Bell | Texas | 48027 | 22169 | 424 |
1247710 | 1247710 | 2021-04-22 | Bell | Texas | 48027 | 22134 | 424 |
1244463 | 1244463 | 2021-04-21 | Bell | Texas | 48027 | 22087 | 423 |
1241216 | 1241216 | 2021-04-20 | Bell | Texas | 48027 | 22058 | 422 |
1237969 | 1237969 | 2021-04-19 | Bell | Texas | 48027 | 21958 | 422 |
1234722 | 1234722 | 2021-04-18 | Bell | Texas | 48027 | 21958 | 421 |
1231474 | 1231474 | 2021-04-17 | Bell | Texas | 48027 | 21958 | 421 |
1228226 | 1228226 | 2021-04-16 | Bell | Texas | 48027 | 21958 | 421 |
1224978 | 1224978 | 2021-04-15 | Bell | Texas | 48027 | 21914 | 421 |
1221731 | 1221731 | 2021-04-14 | Bell | Texas | 48027 | 21894 | 421 |
1218483 | 1218483 | 2021-04-13 | Bell | Texas | 48027 | 21845 | 420 |
1215235 | 1215235 | 2021-04-12 | Bell | Texas | 48027 | 21785 | 420 |
1211988 | 1211988 | 2021-04-11 | Bell | Texas | 48027 | 21785 | 413 |
1208739 | 1208739 | 2021-04-10 | Bell | Texas | 48027 | 21785 | 413 |
1205491 | 1205491 | 2021-04-09 | Bell | Texas | 48027 | 21785 | 413 |
1202243 | 1202243 | 2021-04-08 | Bell | Texas | 48027 | 21761 | 413 |
1198994 | 1198994 | 2021-04-07 | Bell | Texas | 48027 | 21741 | 411 |
1195745 | 1195745 | 2021-04-06 | Bell | Texas | 48027 | 21724 | 411 |
1192497 | 1192497 | 2021-04-05 | Bell | Texas | 48027 | 21629 | 410 |
1189248 | 1189248 | 2021-04-04 | Bell | Texas | 48027 | 21629 | 410 |
1186001 | 1186001 | 2021-04-03 | Bell | Texas | 48027 | 21629 | 410 |
1182754 | 1182754 | 2021-04-02 | Bell | Texas | 48027 | 21629 | 410 |
1179507 | 1179507 | 2021-04-01 | Bell | Texas | 48027 | 21610 | 410 |
1176260 | 1176260 | 2021-03-31 | Bell | Texas | 48027 | 21551 | 409 |
1173013 | 1173013 | 2021-03-30 | Bell | Texas | 48027 | 21486 | 408 |
1169766 | 1169766 | 2021-03-29 | Bell | Texas | 48027 | 21437 | 408 |
1166518 | 1166518 | 2021-03-28 | Bell | Texas | 48027 | 21437 | 408 |
1163270 | 1163270 | 2021-03-27 | Bell | Texas | 48027 | 21437 | 408 |
1160021 | 1160021 | 2021-03-26 | Bell | Texas | 48027 | 21395 | 408 |
1156774 | 1156774 | 2021-03-25 | Bell | Texas | 48027 | 21366 | 408 |
1153527 | 1153527 | 2021-03-24 | Bell | Texas | 48027 | 21335 | 408 |
1150280 | 1150280 | 2021-03-23 | Bell | Texas | 48027 | 21294 | 408 |
1147033 | 1147033 | 2021-03-22 | Bell | Texas | 48027 | 21260 | 408 |
1143786 | 1143786 | 2021-03-21 | Bell | Texas | 48027 | 21260 | 406 |
1140539 | 1140539 | 2021-03-20 | Bell | Texas | 48027 | 21260 | 406 |
1137293 | 1137293 | 2021-03-19 | Bell | Texas | 48027 | 21222 | 406 |
1134047 | 1134047 | 2021-03-18 | Bell | Texas | 48027 | 21200 | 405 |
1130799 | 1130799 | 2021-03-17 | Bell | Texas | 48027 | 21175 | 403 |
1127552 | 1127552 | 2021-03-16 | Bell | Texas | 48027 | 21113 | 401 |
1124306 | 1124306 | 2021-03-15 | Bell | Texas | 48027 | 21052 | 401 |
1121060 | 1121060 | 2021-03-14 | Bell | Texas | 48027 | 21052 | 401 |
1117813 | 1117813 | 2021-03-13 | Bell | Texas | 48027 | 21052 | 401 |
1114566 | 1114566 | 2021-03-12 | Bell | Texas | 48027 | 21006 | 401 |
1111320 | 1111320 | 2021-03-11 | Bell | Texas | 48027 | 20952 | 395 |
1108074 | 1108074 | 2021-03-10 | Bell | Texas | 48027 | 20920 | 395 |
1104828 | 1104828 | 2021-03-09 | Bell | Texas | 48027 | 20871 | 392 |
1101582 | 1101582 | 2021-03-08 | Bell | Texas | 48027 | 20810 | 387 |
1098336 | 1098336 | 2021-03-07 | Bell | Texas | 48027 | 20810 | 385 |
1095088 | 1095088 | 2021-03-06 | Bell | Texas | 48027 | 20810 | 385 |
1091842 | 1091842 | 2021-03-05 | Bell | Texas | 48027 | 20777 | 385 |
1088596 | 1088596 | 2021-03-04 | Bell | Texas | 48027 | 20717 | 379 |
1085351 | 1085351 | 2021-03-03 | Bell | Texas | 48027 | 20668 | 377 |
1082105 | 1082105 | 2021-03-02 | Bell | Texas | 48027 | 20627 | 377 |
1078859 | 1078859 | 2021-03-01 | Bell | Texas | 48027 | 20547 | 374 |
1075614 | 1075614 | 2021-02-28 | Bell | Texas | 48027 | 20547 | 364 |
1072368 | 1072368 | 2021-02-27 | Bell | Texas | 48027 | 20547 | 364 |
1069122 | 1069122 | 2021-02-26 | Bell | Texas | 48027 | 20484 | 364 |
1065877 | 1065877 | 2021-02-25 | Bell | Texas | 48027 | 20400 | 360 |
1062632 | 1062632 | 2021-02-24 | Bell | Texas | 48027 | 20323 | 356 |
1059387 | 1059387 | 2021-02-23 | Bell | Texas | 48027 | 20235 | 351 |
1056141 | 1056141 | 2021-02-22 | Bell | Texas | 48027 | 20148 | 338 |
1052895 | 1052895 | 2021-02-21 | Bell | Texas | 48027 | 20148 | 325 |
1049648 | 1049648 | 2021-02-20 | Bell | Texas | 48027 | 20148 | 320 |
1046401 | 1046401 | 2021-02-19 | Bell | Texas | 48027 | 20148 | 320 |
1043156 | 1043156 | 2021-02-18 | Bell | Texas | 48027 | 20148 | 320 |
1039911 | 1039911 | 2021-02-17 | Bell | Texas | 48027 | 20148 | 320 |
1036666 | 1036666 | 2021-02-16 | Bell | Texas | 48027 | 20122 | 320 |
1033421 | 1033421 | 2021-02-15 | Bell | Texas | 48027 | 20122 | 310 |
1030175 | 1030175 | 2021-02-14 | Bell | Texas | 48027 | 20122 | 310 |
1026928 | 1026928 | 2021-02-13 | Bell | Texas | 48027 | 20122 | 310 |
1023683 | 1023683 | 2021-02-12 | Bell | Texas | 48027 | 20049 | 309 |
1020438 | 1020438 | 2021-02-11 | Bell | Texas | 48027 | 19987 | 304 |
1017193 | 1017193 | 2021-02-10 | Bell | Texas | 48027 | 19878 | 301 |
1013948 | 1013948 | 2021-02-09 | Bell | Texas | 48027 | 19775 | 297 |
1010703 | 1010703 | 2021-02-08 | Bell | Texas | 48027 | 19669 | 297 |
1007457 | 1007457 | 2021-02-07 | Bell | Texas | 48027 | 19602 | 295 |
1004211 | 1004211 | 2021-02-06 | Bell | Texas | 48027 | 19602 | 295 |
1000965 | 1000965 | 2021-02-05 | Bell | Texas | 48027 | 19496 | 287 |
997719 | 997719 | 2021-02-04 | Bell | Texas | 48027 | 19387 | 280 |
994473 | 994473 | 2021-02-03 | Bell | Texas | 48027 | 19243 | 273 |
991227 | 991227 | 2021-02-02 | Bell | Texas | 48027 | 19137 | 268 |
987981 | 987981 | 2021-02-01 | Bell | Texas | 48027 | 18910 | 266 |
984734 | 984734 | 2021-01-31 | Bell | Texas | 48027 | 18729 | 265 |
981487 | 981487 | 2021-01-30 | Bell | Texas | 48027 | 18729 | 263 |
978241 | 978241 | 2021-01-29 | Bell | Texas | 48027 | 18623 | 257 |
974996 | 974996 | 2021-01-28 | Bell | Texas | 48027 | 18048 | 248 |
971751 | 971751 | 2021-01-27 | Bell | Texas | 48027 | 17931 | 242 |
968506 | 968506 | 2021-01-26 | Bell | Texas | 48027 | 17806 | 238 |
965262 | 965262 | 2021-01-25 | Bell | Texas | 48027 | 17646 | 233 |
962017 | 962017 | 2021-01-24 | Bell | Texas | 48027 | 17499 | 233 |
958772 | 958772 | 2021-01-23 | Bell | Texas | 48027 | 17499 | 230 |
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);