ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Prince William" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280569 | 1280569 | 2021-05-02 | Prince William | Virginia | 51153 | 44663 | 482 |
1277322 | 1277322 | 2021-05-01 | Prince William | Virginia | 51153 | 44613 | 482 |
1274075 | 1274075 | 2021-04-30 | Prince William | Virginia | 51153 | 44573 | 481 |
1270828 | 1270828 | 2021-04-29 | Prince William | Virginia | 51153 | 44541 | 480 |
1267581 | 1267581 | 2021-04-28 | Prince William | Virginia | 51153 | 44491 | 479 |
1264334 | 1264334 | 2021-04-27 | Prince William | Virginia | 51153 | 44414 | 479 |
1261087 | 1261087 | 2021-04-26 | Prince William | Virginia | 51153 | 44348 | 479 |
1257840 | 1257840 | 2021-04-25 | Prince William | Virginia | 51153 | 44300 | 479 |
1254593 | 1254593 | 2021-04-24 | Prince William | Virginia | 51153 | 44248 | 479 |
1251346 | 1251346 | 2021-04-23 | Prince William | Virginia | 51153 | 44173 | 479 |
1248099 | 1248099 | 2021-04-22 | Prince William | Virginia | 51153 | 44092 | 479 |
1244852 | 1244852 | 2021-04-21 | Prince William | Virginia | 51153 | 44031 | 480 |
1241605 | 1241605 | 2021-04-20 | Prince William | Virginia | 51153 | 43957 | 480 |
1238358 | 1238358 | 2021-04-19 | Prince William | Virginia | 51153 | 43890 | 478 |
1235111 | 1235111 | 2021-04-18 | Prince William | Virginia | 51153 | 43825 | 478 |
1231863 | 1231863 | 2021-04-17 | Prince William | Virginia | 51153 | 43729 | 477 |
1228615 | 1228615 | 2021-04-16 | Prince William | Virginia | 51153 | 43614 | 477 |
1225367 | 1225367 | 2021-04-15 | Prince William | Virginia | 51153 | 43521 | 477 |
1222120 | 1222120 | 2021-04-14 | Prince William | Virginia | 51153 | 43437 | 477 |
1218872 | 1218872 | 2021-04-13 | Prince William | Virginia | 51153 | 43368 | 477 |
1215624 | 1215624 | 2021-04-12 | Prince William | Virginia | 51153 | 43241 | 477 |
1212377 | 1212377 | 2021-04-11 | Prince William | Virginia | 51153 | 43117 | 477 |
1209128 | 1209128 | 2021-04-10 | Prince William | Virginia | 51153 | 43035 | 476 |
1205880 | 1205880 | 2021-04-09 | Prince William | Virginia | 51153 | 42913 | 476 |
1202632 | 1202632 | 2021-04-08 | Prince William | Virginia | 51153 | 42828 | 474 |
1199384 | 1199384 | 2021-04-07 | Prince William | Virginia | 51153 | 42655 | 474 |
1196135 | 1196135 | 2021-04-06 | Prince William | Virginia | 51153 | 42552 | 473 |
1192887 | 1192887 | 2021-04-05 | Prince William | Virginia | 51153 | 42473 | 472 |
1189637 | 1189637 | 2021-04-04 | Prince William | Virginia | 51153 | 42394 | 470 |
1186390 | 1186390 | 2021-04-03 | Prince William | Virginia | 51153 | 42304 | 468 |
1183143 | 1183143 | 2021-04-02 | Prince William | Virginia | 51153 | 42187 | 468 |
1179896 | 1179896 | 2021-04-01 | Prince William | Virginia | 51153 | 42096 | 468 |
1176649 | 1176649 | 2021-03-31 | Prince William | Virginia | 51153 | 41934 | 468 |
1173402 | 1173402 | 2021-03-30 | Prince William | Virginia | 51153 | 41873 | 468 |
1170155 | 1170155 | 2021-03-29 | Prince William | Virginia | 51153 | 41780 | 468 |
1166907 | 1166907 | 2021-03-28 | Prince William | Virginia | 51153 | 41710 | 468 |
1163659 | 1163659 | 2021-03-27 | Prince William | Virginia | 51153 | 41618 | 467 |
1160411 | 1160411 | 2021-03-26 | Prince William | Virginia | 51153 | 41508 | 467 |
1157163 | 1157163 | 2021-03-25 | Prince William | Virginia | 51153 | 41324 | 467 |
1153916 | 1153916 | 2021-03-24 | Prince William | Virginia | 51153 | 41228 | 467 |
1150669 | 1150669 | 2021-03-23 | Prince William | Virginia | 51153 | 41153 | 467 |
1147422 | 1147422 | 2021-03-22 | Prince William | Virginia | 51153 | 41062 | 469 |
1144175 | 1144175 | 2021-03-21 | Prince William | Virginia | 51153 | 41016 | 469 |
1140928 | 1140928 | 2021-03-20 | Prince William | Virginia | 51153 | 40969 | 469 |
1137682 | 1137682 | 2021-03-19 | Prince William | Virginia | 51153 | 40885 | 469 |
1134436 | 1134436 | 2021-03-18 | Prince William | Virginia | 51153 | 40795 | 472 |
1131188 | 1131188 | 2021-03-17 | Prince William | Virginia | 51153 | 40625 | 471 |
1127941 | 1127941 | 2021-03-16 | Prince William | Virginia | 51153 | 40547 | 470 |
1124695 | 1124695 | 2021-03-15 | Prince William | Virginia | 51153 | 40483 | 469 |
1121449 | 1121449 | 2021-03-14 | Prince William | Virginia | 51153 | 40412 | 469 |
1118202 | 1118202 | 2021-03-13 | Prince William | Virginia | 51153 | 40338 | 466 |
1114955 | 1114955 | 2021-03-12 | Prince William | Virginia | 51153 | 40264 | 465 |
1111709 | 1111709 | 2021-03-11 | Prince William | Virginia | 51153 | 40172 | 459 |
1108463 | 1108463 | 2021-03-10 | Prince William | Virginia | 51153 | 40115 | 459 |
1105217 | 1105217 | 2021-03-09 | Prince William | Virginia | 51153 | 40055 | 458 |
1101971 | 1101971 | 2021-03-08 | Prince William | Virginia | 51153 | 39983 | 454 |
1098725 | 1098725 | 2021-03-07 | Prince William | Virginia | 51153 | 39936 | 451 |
1095477 | 1095477 | 2021-03-06 | Prince William | Virginia | 51153 | 39868 | 450 |
1092231 | 1092231 | 2021-03-05 | Prince William | Virginia | 51153 | 39767 | 446 |
1088985 | 1088985 | 2021-03-04 | Prince William | Virginia | 51153 | 39667 | 442 |
1085740 | 1085740 | 2021-03-03 | Prince William | Virginia | 51153 | 39570 | 441 |
1082494 | 1082494 | 2021-03-02 | Prince William | Virginia | 51153 | 39472 | 424 |
1079248 | 1079248 | 2021-03-01 | Prince William | Virginia | 51153 | 39398 | 420 |
1076003 | 1076003 | 2021-02-28 | Prince William | Virginia | 51153 | 39333 | 404 |
1072757 | 1072757 | 2021-02-27 | Prince William | Virginia | 51153 | 39211 | 398 |
1069511 | 1069511 | 2021-02-26 | Prince William | Virginia | 51153 | 39150 | 389 |
1066266 | 1066266 | 2021-02-25 | Prince William | Virginia | 51153 | 39029 | 375 |
1063021 | 1063021 | 2021-02-24 | Prince William | Virginia | 51153 | 38920 | 368 |
1059776 | 1059776 | 2021-02-23 | Prince William | Virginia | 51153 | 38832 | 358 |
1056530 | 1056530 | 2021-02-22 | Prince William | Virginia | 51153 | 38744 | 354 |
1053284 | 1053284 | 2021-02-21 | Prince William | Virginia | 51153 | 38678 | 345 |
1050037 | 1050037 | 2021-02-20 | Prince William | Virginia | 51153 | 38518 | 334 |
1046790 | 1046790 | 2021-02-19 | Prince William | Virginia | 51153 | 38420 | 328 |
1043545 | 1043545 | 2021-02-18 | Prince William | Virginia | 51153 | 38318 | 328 |
1040300 | 1040300 | 2021-02-17 | Prince William | Virginia | 51153 | 38197 | 328 |
1037055 | 1037055 | 2021-02-16 | Prince William | Virginia | 51153 | 38070 | 327 |
1033810 | 1033810 | 2021-02-15 | Prince William | Virginia | 51153 | 37969 | 327 |
1030564 | 1030564 | 2021-02-14 | Prince William | Virginia | 51153 | 37886 | 327 |
1027317 | 1027317 | 2021-02-13 | Prince William | Virginia | 51153 | 37753 | 327 |
1024072 | 1024072 | 2021-02-12 | Prince William | Virginia | 51153 | 37556 | 326 |
1020827 | 1020827 | 2021-02-11 | Prince William | Virginia | 51153 | 37422 | 327 |
1017582 | 1017582 | 2021-02-10 | Prince William | Virginia | 51153 | 37184 | 327 |
1014337 | 1014337 | 2021-02-09 | Prince William | Virginia | 51153 | 36916 | 326 |
1011092 | 1011092 | 2021-02-08 | Prince William | Virginia | 51153 | 36668 | 324 |
1007846 | 1007846 | 2021-02-07 | Prince William | Virginia | 51153 | 36581 | 324 |
1004600 | 1004600 | 2021-02-06 | Prince William | Virginia | 51153 | 36413 | 325 |
1001354 | 1001354 | 2021-02-05 | Prince William | Virginia | 51153 | 36126 | 324 |
998108 | 998108 | 2021-02-04 | Prince William | Virginia | 51153 | 35862 | 321 |
994862 | 994862 | 2021-02-03 | Prince William | Virginia | 51153 | 35693 | 317 |
991616 | 991616 | 2021-02-02 | Prince William | Virginia | 51153 | 35573 | 315 |
988370 | 988370 | 2021-02-01 | Prince William | Virginia | 51153 | 35412 | 313 |
985123 | 985123 | 2021-01-31 | Prince William | Virginia | 51153 | 35245 | 313 |
981876 | 981876 | 2021-01-30 | Prince William | Virginia | 51153 | 35092 | 313 |
978630 | 978630 | 2021-01-29 | Prince William | Virginia | 51153 | 34751 | 308 |
975385 | 975385 | 2021-01-28 | Prince William | Virginia | 51153 | 34545 | 302 |
972140 | 972140 | 2021-01-27 | Prince William | Virginia | 51153 | 34314 | 295 |
968895 | 968895 | 2021-01-26 | Prince William | Virginia | 51153 | 34036 | 291 |
965651 | 965651 | 2021-01-25 | Prince William | Virginia | 51153 | 33739 | 285 |
962406 | 962406 | 2021-01-24 | Prince William | Virginia | 51153 | 33260 | 285 |
959161 | 959161 | 2021-01-23 | Prince William | Virginia | 51153 | 33048 | 285 |
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);