ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 51001 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280469 | 1280469 | 2021-05-02 | Accomack | Virginia | 51001 | 2812 | 41 |
1277222 | 1277222 | 2021-05-01 | Accomack | Virginia | 51001 | 2811 | 41 |
1273975 | 1273975 | 2021-04-30 | Accomack | Virginia | 51001 | 2810 | 41 |
1270728 | 1270728 | 2021-04-29 | Accomack | Virginia | 51001 | 2803 | 40 |
1267481 | 1267481 | 2021-04-28 | Accomack | Virginia | 51001 | 2798 | 40 |
1264234 | 1264234 | 2021-04-27 | Accomack | Virginia | 51001 | 2795 | 40 |
1260987 | 1260987 | 2021-04-26 | Accomack | Virginia | 51001 | 2789 | 40 |
1257740 | 1257740 | 2021-04-25 | Accomack | Virginia | 51001 | 2788 | 40 |
1254493 | 1254493 | 2021-04-24 | Accomack | Virginia | 51001 | 2786 | 40 |
1251246 | 1251246 | 2021-04-23 | Accomack | Virginia | 51001 | 2781 | 40 |
1247999 | 1247999 | 2021-04-22 | Accomack | Virginia | 51001 | 2777 | 40 |
1244752 | 1244752 | 2021-04-21 | Accomack | Virginia | 51001 | 2778 | 40 |
1241505 | 1241505 | 2021-04-20 | Accomack | Virginia | 51001 | 2776 | 40 |
1238258 | 1238258 | 2021-04-19 | Accomack | Virginia | 51001 | 2775 | 40 |
1235011 | 1235011 | 2021-04-18 | Accomack | Virginia | 51001 | 2773 | 40 |
1231763 | 1231763 | 2021-04-17 | Accomack | Virginia | 51001 | 2770 | 40 |
1228515 | 1228515 | 2021-04-16 | Accomack | Virginia | 51001 | 2763 | 40 |
1225267 | 1225267 | 2021-04-15 | Accomack | Virginia | 51001 | 2762 | 40 |
1222020 | 1222020 | 2021-04-14 | Accomack | Virginia | 51001 | 2756 | 40 |
1218772 | 1218772 | 2021-04-13 | Accomack | Virginia | 51001 | 2750 | 40 |
1215524 | 1215524 | 2021-04-12 | Accomack | Virginia | 51001 | 2747 | 40 |
1212277 | 1212277 | 2021-04-11 | Accomack | Virginia | 51001 | 2744 | 40 |
1209028 | 1209028 | 2021-04-10 | Accomack | Virginia | 51001 | 2742 | 40 |
1205780 | 1205780 | 2021-04-09 | Accomack | Virginia | 51001 | 2739 | 40 |
1202532 | 1202532 | 2021-04-08 | Accomack | Virginia | 51001 | 2735 | 39 |
1199284 | 1199284 | 2021-04-07 | Accomack | Virginia | 51001 | 2730 | 39 |
1196035 | 1196035 | 2021-04-06 | Accomack | Virginia | 51001 | 2727 | 39 |
1192787 | 1192787 | 2021-04-05 | Accomack | Virginia | 51001 | 2724 | 39 |
1189537 | 1189537 | 2021-04-04 | Accomack | Virginia | 51001 | 2719 | 39 |
1186290 | 1186290 | 2021-04-03 | Accomack | Virginia | 51001 | 2717 | 39 |
1183043 | 1183043 | 2021-04-02 | Accomack | Virginia | 51001 | 2716 | 39 |
1179796 | 1179796 | 2021-04-01 | Accomack | Virginia | 51001 | 2710 | 39 |
1176549 | 1176549 | 2021-03-31 | Accomack | Virginia | 51001 | 2709 | 39 |
1173302 | 1173302 | 2021-03-30 | Accomack | Virginia | 51001 | 2709 | 39 |
1170055 | 1170055 | 2021-03-29 | Accomack | Virginia | 51001 | 2704 | 37 |
1166807 | 1166807 | 2021-03-28 | Accomack | Virginia | 51001 | 2703 | 37 |
1163559 | 1163559 | 2021-03-27 | Accomack | Virginia | 51001 | 2695 | 37 |
1160311 | 1160311 | 2021-03-26 | Accomack | Virginia | 51001 | 2691 | 37 |
1157063 | 1157063 | 2021-03-25 | Accomack | Virginia | 51001 | 2686 | 37 |
1153816 | 1153816 | 2021-03-24 | Accomack | Virginia | 51001 | 2686 | 37 |
1150569 | 1150569 | 2021-03-23 | Accomack | Virginia | 51001 | 2688 | 37 |
1147322 | 1147322 | 2021-03-22 | Accomack | Virginia | 51001 | 2685 | 37 |
1144075 | 1144075 | 2021-03-21 | Accomack | Virginia | 51001 | 2686 | 37 |
1140828 | 1140828 | 2021-03-20 | Accomack | Virginia | 51001 | 2682 | 37 |
1137582 | 1137582 | 2021-03-19 | Accomack | Virginia | 51001 | 2677 | 37 |
1134336 | 1134336 | 2021-03-18 | Accomack | Virginia | 51001 | 2663 | 37 |
1131088 | 1131088 | 2021-03-17 | Accomack | Virginia | 51001 | 2659 | 37 |
1127841 | 1127841 | 2021-03-16 | Accomack | Virginia | 51001 | 2657 | 37 |
1124595 | 1124595 | 2021-03-15 | Accomack | Virginia | 51001 | 2655 | 35 |
1121349 | 1121349 | 2021-03-14 | Accomack | Virginia | 51001 | 2649 | 35 |
1118102 | 1118102 | 2021-03-13 | Accomack | Virginia | 51001 | 2646 | 35 |
1114855 | 1114855 | 2021-03-12 | Accomack | Virginia | 51001 | 2638 | 35 |
1111609 | 1111609 | 2021-03-11 | Accomack | Virginia | 51001 | 2636 | 35 |
1108363 | 1108363 | 2021-03-10 | Accomack | Virginia | 51001 | 2630 | 35 |
1105117 | 1105117 | 2021-03-09 | Accomack | Virginia | 51001 | 2628 | 35 |
1101871 | 1101871 | 2021-03-08 | Accomack | Virginia | 51001 | 2625 | 35 |
1098625 | 1098625 | 2021-03-07 | Accomack | Virginia | 51001 | 2625 | 35 |
1095377 | 1095377 | 2021-03-06 | Accomack | Virginia | 51001 | 2621 | 35 |
1092131 | 1092131 | 2021-03-05 | Accomack | Virginia | 51001 | 2619 | 35 |
1088885 | 1088885 | 2021-03-04 | Accomack | Virginia | 51001 | 2609 | 35 |
1085640 | 1085640 | 2021-03-03 | Accomack | Virginia | 51001 | 2607 | 35 |
1082394 | 1082394 | 2021-03-02 | Accomack | Virginia | 51001 | 2604 | 35 |
1079148 | 1079148 | 2021-03-01 | Accomack | Virginia | 51001 | 2601 | 35 |
1075903 | 1075903 | 2021-02-28 | Accomack | Virginia | 51001 | 2602 | 35 |
1072657 | 1072657 | 2021-02-27 | Accomack | Virginia | 51001 | 2596 | 35 |
1069411 | 1069411 | 2021-02-26 | Accomack | Virginia | 51001 | 2588 | 35 |
1066166 | 1066166 | 2021-02-25 | Accomack | Virginia | 51001 | 2580 | 35 |
1062921 | 1062921 | 2021-02-24 | Accomack | Virginia | 51001 | 2575 | 35 |
1059676 | 1059676 | 2021-02-23 | Accomack | Virginia | 51001 | 2572 | 35 |
1056430 | 1056430 | 2021-02-22 | Accomack | Virginia | 51001 | 2565 | 35 |
1053184 | 1053184 | 2021-02-21 | Accomack | Virginia | 51001 | 2559 | 35 |
1049937 | 1049937 | 2021-02-20 | Accomack | Virginia | 51001 | 2552 | 35 |
1046690 | 1046690 | 2021-02-19 | Accomack | Virginia | 51001 | 2545 | 35 |
1043445 | 1043445 | 2021-02-18 | Accomack | Virginia | 51001 | 2538 | 35 |
1040200 | 1040200 | 2021-02-17 | Accomack | Virginia | 51001 | 2529 | 34 |
1036955 | 1036955 | 2021-02-16 | Accomack | Virginia | 51001 | 2527 | 34 |
1033710 | 1033710 | 2021-02-15 | Accomack | Virginia | 51001 | 2523 | 33 |
1030464 | 1030464 | 2021-02-14 | Accomack | Virginia | 51001 | 2519 | 33 |
1027217 | 1027217 | 2021-02-13 | Accomack | Virginia | 51001 | 2516 | 33 |
1023972 | 1023972 | 2021-02-12 | Accomack | Virginia | 51001 | 2506 | 33 |
1020727 | 1020727 | 2021-02-11 | Accomack | Virginia | 51001 | 2485 | 33 |
1017482 | 1017482 | 2021-02-10 | Accomack | Virginia | 51001 | 2473 | 33 |
1014237 | 1014237 | 2021-02-09 | Accomack | Virginia | 51001 | 2467 | 33 |
1010992 | 1010992 | 2021-02-08 | Accomack | Virginia | 51001 | 2461 | 33 |
1007746 | 1007746 | 2021-02-07 | Accomack | Virginia | 51001 | 2457 | 33 |
1004500 | 1004500 | 2021-02-06 | Accomack | Virginia | 51001 | 2448 | 33 |
1001254 | 1001254 | 2021-02-05 | Accomack | Virginia | 51001 | 2428 | 32 |
998008 | 998008 | 2021-02-04 | Accomack | Virginia | 51001 | 2403 | 32 |
994762 | 994762 | 2021-02-03 | Accomack | Virginia | 51001 | 2391 | 32 |
991516 | 991516 | 2021-02-02 | Accomack | Virginia | 51001 | 2388 | 32 |
988270 | 988270 | 2021-02-01 | Accomack | Virginia | 51001 | 2365 | 31 |
985023 | 985023 | 2021-01-31 | Accomack | Virginia | 51001 | 2342 | 31 |
981776 | 981776 | 2021-01-30 | Accomack | Virginia | 51001 | 2333 | 31 |
978530 | 978530 | 2021-01-29 | Accomack | Virginia | 51001 | 2324 | 31 |
975285 | 975285 | 2021-01-28 | Accomack | Virginia | 51001 | 2301 | 31 |
972040 | 972040 | 2021-01-27 | Accomack | Virginia | 51001 | 2295 | 31 |
968795 | 968795 | 2021-01-26 | Accomack | Virginia | 51001 | 2290 | 31 |
965551 | 965551 | 2021-01-25 | Accomack | Virginia | 51001 | 2272 | 31 |
962306 | 962306 | 2021-01-24 | Accomack | Virginia | 51001 | 2249 | 31 |
959061 | 959061 | 2021-01-23 | Accomack | Virginia | 51001 | 2228 | 31 |
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);