ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,036 rows where deaths = 27 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Westmoreland 80
- Charles City 75
- King William 44
- King George 36
- Martinsville city 34
- Mathews 33
- Patrick 29
- Fauquier 28
- Manassas Park city 25
- Fredericksburg city 23
- Isle of Wight 23
- Lynchburg city 23
- Charlotte 22
- Poquoson city 22
- Smyth 22
- Manassas city 21
- Bristol city 19
- Louisa 18
- New Kent 18
- Powhatan 18
- Richmond 18
- Rockingham 18
- Cumberland 17
- Sussex 16
- Virginia Beach city 16
- Waynesboro city 15
- Albemarle 14
- Brunswick 14
- Goochland 14
- Greensville 14
- …
state 1
- Virginia · 1,036 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502531 | 2502531 | 2022-05-13 | Charles City | Virginia | 51036 | 1191 | 27 |
2502541 | 2502541 | 2022-05-13 | Cumberland | Virginia | 51049 | 1366 | 27 |
2502585 | 2502585 | 2022-05-13 | Manassas Park city | Virginia | 51685 | 3828 | 27 |
2502588 | 2502588 | 2022-05-13 | Mathews | Virginia | 51115 | 1524 | 27 |
2499273 | 2499273 | 2022-05-12 | Charles City | Virginia | 51036 | 1189 | 27 |
2499283 | 2499283 | 2022-05-12 | Cumberland | Virginia | 51049 | 1364 | 27 |
2499327 | 2499327 | 2022-05-12 | Manassas Park city | Virginia | 51685 | 3826 | 27 |
2499330 | 2499330 | 2022-05-12 | Mathews | Virginia | 51115 | 1523 | 27 |
2496015 | 2496015 | 2022-05-11 | Charles City | Virginia | 51036 | 1189 | 27 |
2496025 | 2496025 | 2022-05-11 | Cumberland | Virginia | 51049 | 1358 | 27 |
2496069 | 2496069 | 2022-05-11 | Manassas Park city | Virginia | 51685 | 3819 | 27 |
2496072 | 2496072 | 2022-05-11 | Mathews | Virginia | 51115 | 1523 | 27 |
2492757 | 2492757 | 2022-05-10 | Charles City | Virginia | 51036 | 1186 | 27 |
2492767 | 2492767 | 2022-05-10 | Cumberland | Virginia | 51049 | 1356 | 27 |
2492811 | 2492811 | 2022-05-10 | Manassas Park city | Virginia | 51685 | 3816 | 27 |
2492814 | 2492814 | 2022-05-10 | Mathews | Virginia | 51115 | 1522 | 27 |
2489499 | 2489499 | 2022-05-09 | Charles City | Virginia | 51036 | 1180 | 27 |
2489509 | 2489509 | 2022-05-09 | Cumberland | Virginia | 51049 | 1354 | 27 |
2489553 | 2489553 | 2022-05-09 | Manassas Park city | Virginia | 51685 | 3809 | 27 |
2489556 | 2489556 | 2022-05-09 | Mathews | Virginia | 51115 | 1521 | 27 |
2486242 | 2486242 | 2022-05-08 | Charles City | Virginia | 51036 | 1175 | 27 |
2486252 | 2486252 | 2022-05-08 | Cumberland | Virginia | 51049 | 1353 | 27 |
2486296 | 2486296 | 2022-05-08 | Manassas Park city | Virginia | 51685 | 3805 | 27 |
2486299 | 2486299 | 2022-05-08 | Mathews | Virginia | 51115 | 1517 | 27 |
2482984 | 2482984 | 2022-05-07 | Charles City | Virginia | 51036 | 1175 | 27 |
2482994 | 2482994 | 2022-05-07 | Cumberland | Virginia | 51049 | 1353 | 27 |
2483038 | 2483038 | 2022-05-07 | Manassas Park city | Virginia | 51685 | 3805 | 27 |
2483041 | 2483041 | 2022-05-07 | Mathews | Virginia | 51115 | 1517 | 27 |
2479726 | 2479726 | 2022-05-06 | Charles City | Virginia | 51036 | 1175 | 27 |
2479736 | 2479736 | 2022-05-06 | Cumberland | Virginia | 51049 | 1353 | 27 |
2479780 | 2479780 | 2022-05-06 | Manassas Park city | Virginia | 51685 | 3805 | 27 |
2479783 | 2479783 | 2022-05-06 | Mathews | Virginia | 51115 | 1517 | 27 |
2476468 | 2476468 | 2022-05-05 | Charles City | Virginia | 51036 | 1175 | 27 |
2476478 | 2476478 | 2022-05-05 | Cumberland | Virginia | 51049 | 1349 | 27 |
2476522 | 2476522 | 2022-05-05 | Manassas Park city | Virginia | 51685 | 3805 | 27 |
2476525 | 2476525 | 2022-05-05 | Mathews | Virginia | 51115 | 1515 | 27 |
2473210 | 2473210 | 2022-05-04 | Charles City | Virginia | 51036 | 1175 | 27 |
2473220 | 2473220 | 2022-05-04 | Cumberland | Virginia | 51049 | 1344 | 27 |
2473264 | 2473264 | 2022-05-04 | Manassas Park city | Virginia | 51685 | 3805 | 27 |
2473267 | 2473267 | 2022-05-04 | Mathews | Virginia | 51115 | 1513 | 27 |
2469954 | 2469954 | 2022-05-03 | Charles City | Virginia | 51036 | 1172 | 27 |
2469964 | 2469964 | 2022-05-03 | Cumberland | Virginia | 51049 | 1343 | 27 |
2470008 | 2470008 | 2022-05-03 | Manassas Park city | Virginia | 51685 | 3799 | 27 |
2470011 | 2470011 | 2022-05-03 | Mathews | Virginia | 51115 | 1512 | 27 |
2466698 | 2466698 | 2022-05-02 | Charles City | Virginia | 51036 | 1171 | 27 |
2466708 | 2466708 | 2022-05-02 | Cumberland | Virginia | 51049 | 1343 | 27 |
2466752 | 2466752 | 2022-05-02 | Manassas Park city | Virginia | 51685 | 3799 | 27 |
2466755 | 2466755 | 2022-05-02 | Mathews | Virginia | 51115 | 1512 | 27 |
2463443 | 2463443 | 2022-05-01 | Charles City | Virginia | 51036 | 1170 | 27 |
2463453 | 2463453 | 2022-05-01 | Cumberland | Virginia | 51049 | 1343 | 27 |
2463497 | 2463497 | 2022-05-01 | Manassas Park city | Virginia | 51685 | 3798 | 27 |
2463500 | 2463500 | 2022-05-01 | Mathews | Virginia | 51115 | 1497 | 27 |
2460187 | 2460187 | 2022-04-30 | Charles City | Virginia | 51036 | 1170 | 27 |
2460197 | 2460197 | 2022-04-30 | Cumberland | Virginia | 51049 | 1343 | 27 |
2460241 | 2460241 | 2022-04-30 | Manassas Park city | Virginia | 51685 | 3798 | 27 |
2460244 | 2460244 | 2022-04-30 | Mathews | Virginia | 51115 | 1497 | 27 |
2456931 | 2456931 | 2022-04-29 | Charles City | Virginia | 51036 | 1170 | 27 |
2456941 | 2456941 | 2022-04-29 | Cumberland | Virginia | 51049 | 1343 | 27 |
2456985 | 2456985 | 2022-04-29 | Manassas Park city | Virginia | 51685 | 3798 | 27 |
2456988 | 2456988 | 2022-04-29 | Mathews | Virginia | 51115 | 1497 | 27 |
2453675 | 2453675 | 2022-04-28 | Charles City | Virginia | 51036 | 1168 | 27 |
2453685 | 2453685 | 2022-04-28 | Cumberland | Virginia | 51049 | 1340 | 27 |
2453729 | 2453729 | 2022-04-28 | Manassas Park city | Virginia | 51685 | 3797 | 27 |
2453732 | 2453732 | 2022-04-28 | Mathews | Virginia | 51115 | 1495 | 27 |
2450419 | 2450419 | 2022-04-27 | Charles City | Virginia | 51036 | 1166 | 27 |
2450429 | 2450429 | 2022-04-27 | Cumberland | Virginia | 51049 | 1336 | 27 |
2450473 | 2450473 | 2022-04-27 | Manassas Park city | Virginia | 51685 | 3794 | 27 |
2450476 | 2450476 | 2022-04-27 | Mathews | Virginia | 51115 | 1492 | 27 |
2447162 | 2447162 | 2022-04-26 | Charles City | Virginia | 51036 | 1163 | 27 |
2447216 | 2447216 | 2022-04-26 | Manassas Park city | Virginia | 51685 | 3793 | 27 |
2447219 | 2447219 | 2022-04-26 | Mathews | Virginia | 51115 | 1482 | 27 |
2443907 | 2443907 | 2022-04-25 | Charles City | Virginia | 51036 | 1162 | 27 |
2443961 | 2443961 | 2022-04-25 | Manassas Park city | Virginia | 51685 | 3788 | 27 |
2443964 | 2443964 | 2022-04-25 | Mathews | Virginia | 51115 | 1481 | 27 |
2440651 | 2440651 | 2022-04-24 | Charles City | Virginia | 51036 | 1160 | 27 |
2440705 | 2440705 | 2022-04-24 | Manassas Park city | Virginia | 51685 | 3787 | 27 |
2437395 | 2437395 | 2022-04-23 | Charles City | Virginia | 51036 | 1160 | 27 |
2437449 | 2437449 | 2022-04-23 | Manassas Park city | Virginia | 51685 | 3787 | 27 |
2434139 | 2434139 | 2022-04-22 | Charles City | Virginia | 51036 | 1160 | 27 |
2434193 | 2434193 | 2022-04-22 | Manassas Park city | Virginia | 51685 | 3787 | 27 |
2430883 | 2430883 | 2022-04-21 | Charles City | Virginia | 51036 | 1159 | 27 |
2430937 | 2430937 | 2022-04-21 | Manassas Park city | Virginia | 51685 | 3783 | 27 |
2427627 | 2427627 | 2022-04-20 | Charles City | Virginia | 51036 | 1158 | 27 |
2427681 | 2427681 | 2022-04-20 | Manassas Park city | Virginia | 51685 | 3783 | 27 |
2424371 | 2424371 | 2022-04-19 | Charles City | Virginia | 51036 | 1158 | 27 |
2424425 | 2424425 | 2022-04-19 | Manassas Park city | Virginia | 51685 | 3784 | 27 |
2421115 | 2421115 | 2022-04-18 | Charles City | Virginia | 51036 | 1158 | 27 |
2417859 | 2417859 | 2022-04-17 | Charles City | Virginia | 51036 | 1157 | 27 |
2414603 | 2414603 | 2022-04-16 | Charles City | Virginia | 51036 | 1157 | 27 |
2411347 | 2411347 | 2022-04-15 | Charles City | Virginia | 51036 | 1157 | 27 |
2408091 | 2408091 | 2022-04-14 | Charles City | Virginia | 51036 | 1156 | 27 |
2404835 | 2404835 | 2022-04-13 | Charles City | Virginia | 51036 | 1156 | 27 |
2401580 | 2401580 | 2022-04-12 | Charles City | Virginia | 51036 | 1155 | 27 |
2398325 | 2398325 | 2022-04-11 | Charles City | Virginia | 51036 | 1155 | 27 |
2395070 | 2395070 | 2022-04-10 | Charles City | Virginia | 51036 | 1153 | 27 |
2391814 | 2391814 | 2022-04-09 | Charles City | Virginia | 51036 | 1153 | 27 |
2388558 | 2388558 | 2022-04-08 | Charles City | Virginia | 51036 | 1153 | 27 |
2385303 | 2385303 | 2022-04-07 | Charles City | Virginia | 51036 | 1153 | 27 |
2382048 | 2382048 | 2022-04-06 | Charles City | Virginia | 51036 | 1153 | 27 |
2378793 | 2378793 | 2022-04-05 | Charles City | Virginia | 51036 | 1153 | 27 |
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);