ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103,128 rows where state = "Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 51059 798
- 51810 796
- 51107 795
- 51013 794
- 51085 793
- 51095 793
- 51147 793
- 51153 793
- 51510 793
- 51660 792
- 51041 791
- 51177 791
- 51179 789
- 51199 789
- 51075 788
- 51087 788
- 51540 788
- 51830 788
- 51036 787
- 51760 787
- 51073 785
- 51700 785
- 51710 785
- 51740 785
- 51003 784
- 51023 784
- 51067 784
- 51093 784
- 51117 784
- 51800 784
- …
county >30
- Fairfax 798
- Virginia Beach city 796
- Loudoun 795
- Arlington 794
- Alexandria city 793
- Hanover 793
- James City 793
- Prince Edward 793
- Prince William 793
- Harrisonburg city 792
- Chesterfield 791
- Spotsylvania 791
- Stafford 789
- York 789
- Charlottesville city 788
- Goochland 788
- Henrico 788
- Williamsburg city 788
- Charles City 787
- Richmond city 787
- Gloucester 785
- Newport News city 785
- Norfolk city 785
- Portsmouth city 785
- Albemarle 784
- Botetourt 784
- Franklin 784
- Isle of Wight 784
- Mecklenburg 784
- Suffolk city 784
- …
state 1
- Virginia · 103,028 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
283615 | 283615 | 2020-06-28 | Accomack | Virginia | 51001 | 1039 | 14 |
286761 | 286761 | 2020-06-29 | Accomack | Virginia | 51001 | 1039 | 14 |
289911 | 289911 | 2020-06-30 | Accomack | Virginia | 51001 | 1042 | 14 |
293064 | 293064 | 2020-07-01 | Accomack | Virginia | 51001 | 1043 | 14 |
296219 | 296219 | 2020-07-02 | Accomack | Virginia | 51001 | 1042 | 14 |
299381 | 299381 | 2020-07-03 | Accomack | Virginia | 51001 | 1042 | 14 |
302545 | 302545 | 2020-07-04 | Accomack | Virginia | 51001 | 1043 | 14 |
305709 | 305709 | 2020-07-05 | Accomack | Virginia | 51001 | 1044 | 14 |
308877 | 308877 | 2020-07-06 | Accomack | Virginia | 51001 | 1044 | 14 |
312046 | 312046 | 2020-07-07 | Accomack | Virginia | 51001 | 1042 | 14 |
315220 | 315220 | 2020-07-08 | Accomack | Virginia | 51001 | 1042 | 14 |
318393 | 318393 | 2020-07-09 | Accomack | Virginia | 51001 | 1042 | 14 |
321572 | 321572 | 2020-07-10 | Accomack | Virginia | 51001 | 1042 | 14 |
324753 | 324753 | 2020-07-11 | Accomack | Virginia | 51001 | 1042 | 14 |
327938 | 327938 | 2020-07-12 | Accomack | Virginia | 51001 | 1042 | 14 |
331124 | 331124 | 2020-07-13 | Accomack | Virginia | 51001 | 1041 | 14 |
334317 | 334317 | 2020-07-14 | Accomack | Virginia | 51001 | 1045 | 14 |
337512 | 337512 | 2020-07-15 | Accomack | Virginia | 51001 | 1045 | 14 |
340708 | 340708 | 2020-07-16 | Accomack | Virginia | 51001 | 1045 | 14 |
343907 | 343907 | 2020-07-17 | Accomack | Virginia | 51001 | 1048 | 14 |
347107 | 347107 | 2020-07-18 | Accomack | Virginia | 51001 | 1051 | 15 |
350308 | 350308 | 2020-07-19 | Accomack | Virginia | 51001 | 1052 | 15 |
353510 | 353510 | 2020-07-20 | Accomack | Virginia | 51001 | 1053 | 15 |
356713 | 356713 | 2020-07-21 | Accomack | Virginia | 51001 | 1057 | 15 |
359918 | 359918 | 2020-07-22 | Accomack | Virginia | 51001 | 1057 | 15 |
363124 | 363124 | 2020-07-23 | Accomack | Virginia | 51001 | 1059 | 15 |
366330 | 366330 | 2020-07-24 | Accomack | Virginia | 51001 | 1059 | 15 |
369539 | 369539 | 2020-07-25 | Accomack | Virginia | 51001 | 1060 | 15 |
372751 | 372751 | 2020-07-26 | Accomack | Virginia | 51001 | 1063 | 15 |
375965 | 375965 | 2020-07-27 | Accomack | Virginia | 51001 | 1065 | 15 |
379181 | 379181 | 2020-07-28 | Accomack | Virginia | 51001 | 1069 | 15 |
382398 | 382398 | 2020-07-29 | Accomack | Virginia | 51001 | 1072 | 15 |
385616 | 385616 | 2020-07-30 | Accomack | Virginia | 51001 | 1074 | 15 |
388833 | 388833 | 2020-07-31 | Accomack | Virginia | 51001 | 1074 | 15 |
392050 | 392050 | 2020-08-01 | Accomack | Virginia | 51001 | 1077 | 15 |
395266 | 395266 | 2020-08-02 | Accomack | Virginia | 51001 | 1079 | 15 |
398482 | 398482 | 2020-08-03 | Accomack | Virginia | 51001 | 1080 | 15 |
401698 | 401698 | 2020-08-04 | Accomack | Virginia | 51001 | 1082 | 15 |
404916 | 404916 | 2020-08-05 | Accomack | Virginia | 51001 | 1085 | 15 |
408136 | 408136 | 2020-08-06 | Accomack | Virginia | 51001 | 1085 | 16 |
411355 | 411355 | 2020-08-07 | Accomack | Virginia | 51001 | 1087 | 16 |
414575 | 414575 | 2020-08-08 | Accomack | Virginia | 51001 | 1095 | 16 |
417796 | 417796 | 2020-08-09 | Accomack | Virginia | 51001 | 1100 | 16 |
421017 | 421017 | 2020-08-10 | Accomack | Virginia | 51001 | 1102 | 16 |
424238 | 424238 | 2020-08-11 | Accomack | Virginia | 51001 | 1106 | 16 |
427462 | 427462 | 2020-08-12 | Accomack | Virginia | 51001 | 1108 | 17 |
430690 | 430690 | 2020-08-13 | Accomack | Virginia | 51001 | 1111 | 17 |
433915 | 433915 | 2020-08-14 | Accomack | Virginia | 51001 | 1116 | 17 |
437141 | 437141 | 2020-08-15 | Accomack | Virginia | 51001 | 1120 | 17 |
440367 | 440367 | 2020-08-16 | Accomack | Virginia | 51001 | 1123 | 17 |
443593 | 443593 | 2020-08-17 | Accomack | Virginia | 51001 | 1127 | 17 |
446820 | 446820 | 2020-08-18 | Accomack | Virginia | 51001 | 1127 | 17 |
450048 | 450048 | 2020-08-19 | Accomack | Virginia | 51001 | 1129 | 18 |
453276 | 453276 | 2020-08-20 | Accomack | Virginia | 51001 | 1131 | 18 |
456504 | 456504 | 2020-08-21 | Accomack | Virginia | 51001 | 1133 | 18 |
459731 | 459731 | 2020-08-22 | Accomack | Virginia | 51001 | 1135 | 18 |
462960 | 462960 | 2020-08-23 | Accomack | Virginia | 51001 | 1135 | 18 |
466189 | 466189 | 2020-08-24 | Accomack | Virginia | 51001 | 1135 | 18 |
469418 | 469418 | 2020-08-25 | Accomack | Virginia | 51001 | 1135 | 18 |
472650 | 472650 | 2020-08-26 | Accomack | Virginia | 51001 | 1136 | 18 |
475883 | 475883 | 2020-08-27 | Accomack | Virginia | 51001 | 1139 | 18 |
479116 | 479116 | 2020-08-28 | Accomack | Virginia | 51001 | 1141 | 19 |
482350 | 482350 | 2020-08-29 | Accomack | Virginia | 51001 | 1143 | 19 |
485585 | 485585 | 2020-08-30 | Accomack | Virginia | 51001 | 1143 | 19 |
488818 | 488818 | 2020-08-31 | Accomack | Virginia | 51001 | 1145 | 19 |
492051 | 492051 | 2020-09-01 | Accomack | Virginia | 51001 | 1148 | 19 |
495285 | 495285 | 2020-09-02 | Accomack | Virginia | 51001 | 1148 | 19 |
498518 | 498518 | 2020-09-03 | Accomack | Virginia | 51001 | 1151 | 19 |
501752 | 501752 | 2020-09-04 | Accomack | Virginia | 51001 | 1151 | 19 |
504986 | 504986 | 2020-09-05 | Accomack | Virginia | 51001 | 1152 | 19 |
508218 | 508218 | 2020-09-06 | Accomack | Virginia | 51001 | 1153 | 19 |
511451 | 511451 | 2020-09-07 | Accomack | Virginia | 51001 | 1153 | 19 |
514684 | 514684 | 2020-09-08 | Accomack | Virginia | 51001 | 1154 | 19 |
517919 | 517919 | 2020-09-09 | Accomack | Virginia | 51001 | 1155 | 19 |
521156 | 521156 | 2020-09-10 | Accomack | Virginia | 51001 | 1156 | 19 |
524392 | 524392 | 2020-09-11 | Accomack | Virginia | 51001 | 1158 | 19 |
527628 | 527628 | 2020-09-12 | Accomack | Virginia | 51001 | 1158 | 19 |
530865 | 530865 | 2020-09-13 | Accomack | Virginia | 51001 | 1159 | 19 |
534100 | 534100 | 2020-09-14 | Accomack | Virginia | 51001 | 1161 | 19 |
537336 | 537336 | 2020-09-15 | Accomack | Virginia | 51001 | 1161 | 19 |
540573 | 540573 | 2020-09-16 | Accomack | Virginia | 51001 | 1161 | 19 |
543809 | 543809 | 2020-09-17 | Accomack | Virginia | 51001 | 1163 | 19 |
547046 | 547046 | 2020-09-18 | Accomack | Virginia | 51001 | 1167 | 19 |
550285 | 550285 | 2020-09-19 | Accomack | Virginia | 51001 | 1166 | 19 |
553524 | 553524 | 2020-09-20 | Accomack | Virginia | 51001 | 1166 | 19 |
556761 | 556761 | 2020-09-21 | Accomack | Virginia | 51001 | 1167 | 19 |
559997 | 559997 | 2020-09-22 | Accomack | Virginia | 51001 | 1167 | 19 |
563236 | 563236 | 2020-09-23 | Accomack | Virginia | 51001 | 1169 | 19 |
566477 | 566477 | 2020-09-24 | Accomack | Virginia | 51001 | 1169 | 19 |
569718 | 569718 | 2020-09-25 | Accomack | Virginia | 51001 | 1172 | 19 |
572960 | 572960 | 2020-09-26 | Accomack | Virginia | 51001 | 1175 | 19 |
576204 | 576204 | 2020-09-27 | Accomack | Virginia | 51001 | 1175 | 19 |
579445 | 579445 | 2020-09-28 | Accomack | Virginia | 51001 | 1175 | 19 |
582684 | 582684 | 2020-09-29 | Accomack | Virginia | 51001 | 1175 | 19 |
585924 | 585924 | 2020-09-30 | Accomack | Virginia | 51001 | 1182 | 19 |
589165 | 589165 | 2020-10-01 | Accomack | Virginia | 51001 | 1182 | 19 |
592405 | 592405 | 2020-10-02 | Accomack | Virginia | 51001 | 1183 | 19 |
595647 | 595647 | 2020-10-03 | Accomack | Virginia | 51001 | 1184 | 19 |
598890 | 598890 | 2020-10-04 | Accomack | Virginia | 51001 | 1185 | 19 |
602133 | 602133 | 2020-10-05 | Accomack | Virginia | 51001 | 1188 | 19 |
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);