ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
897 rows where deaths = 32 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Lexington city 69
- New Kent 61
- Prince George 55
- Louisa 48
- Franklin city 46
- Buckingham 43
- Brunswick 31
- Nelson 31
- Essex 30
- Floyd 25
- Buchanan 24
- Charlotte 22
- Giles 19
- Northampton 19
- Bristol city 18
- Mecklenburg 18
- Amelia 15
- Fluvanna 15
- Salem city 13
- Lee 12
- Emporia city 11
- Goochland 11
- Hampton city 11
- Prince Edward 11
- Roanoke city 11
- Westmoreland 10
- Bedford 9
- Sussex 9
- Charlottesville city 8
- Dickenson 8
- …
state 1
- Virginia · 897 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502593 | 2502593 | 2022-05-13 | New Kent | Virginia | 51127 | 4742 | 32 |
2453737 | 2453737 | 2022-04-28 | New Kent | Virginia | 51127 | 4657 | 32 |
2450481 | 2450481 | 2022-04-27 | New Kent | Virginia | 51127 | 4651 | 32 |
2447224 | 2447224 | 2022-04-26 | New Kent | Virginia | 51127 | 4651 | 32 |
2443969 | 2443969 | 2022-04-25 | New Kent | Virginia | 51127 | 4652 | 32 |
2440713 | 2440713 | 2022-04-24 | New Kent | Virginia | 51127 | 4647 | 32 |
2437457 | 2437457 | 2022-04-23 | New Kent | Virginia | 51127 | 4647 | 32 |
2434201 | 2434201 | 2022-04-22 | New Kent | Virginia | 51127 | 4647 | 32 |
2430898 | 2430898 | 2022-04-21 | Essex | Virginia | 51057 | 2260 | 32 |
2430945 | 2430945 | 2022-04-21 | New Kent | Virginia | 51127 | 4639 | 32 |
2427642 | 2427642 | 2022-04-20 | Essex | Virginia | 51057 | 2259 | 32 |
2427689 | 2427689 | 2022-04-20 | New Kent | Virginia | 51127 | 4637 | 32 |
2424386 | 2424386 | 2022-04-19 | Essex | Virginia | 51057 | 2258 | 32 |
2424433 | 2424433 | 2022-04-19 | New Kent | Virginia | 51127 | 4635 | 32 |
2421130 | 2421130 | 2022-04-18 | Essex | Virginia | 51057 | 2259 | 32 |
2421177 | 2421177 | 2022-04-18 | New Kent | Virginia | 51127 | 4643 | 32 |
2417874 | 2417874 | 2022-04-17 | Essex | Virginia | 51057 | 2258 | 32 |
2417921 | 2417921 | 2022-04-17 | New Kent | Virginia | 51127 | 4630 | 32 |
2414618 | 2414618 | 2022-04-16 | Essex | Virginia | 51057 | 2258 | 32 |
2414665 | 2414665 | 2022-04-16 | New Kent | Virginia | 51127 | 4630 | 32 |
2411362 | 2411362 | 2022-04-15 | Essex | Virginia | 51057 | 2258 | 32 |
2411409 | 2411409 | 2022-04-15 | New Kent | Virginia | 51127 | 4630 | 32 |
2408106 | 2408106 | 2022-04-14 | Essex | Virginia | 51057 | 2259 | 32 |
2408153 | 2408153 | 2022-04-14 | New Kent | Virginia | 51127 | 4628 | 32 |
2404850 | 2404850 | 2022-04-13 | Essex | Virginia | 51057 | 2257 | 32 |
2404897 | 2404897 | 2022-04-13 | New Kent | Virginia | 51127 | 4626 | 32 |
2401595 | 2401595 | 2022-04-12 | Essex | Virginia | 51057 | 2257 | 32 |
2401642 | 2401642 | 2022-04-12 | New Kent | Virginia | 51127 | 4624 | 32 |
2398340 | 2398340 | 2022-04-11 | Essex | Virginia | 51057 | 2257 | 32 |
2398387 | 2398387 | 2022-04-11 | New Kent | Virginia | 51127 | 4624 | 32 |
2395085 | 2395085 | 2022-04-10 | Essex | Virginia | 51057 | 2257 | 32 |
2395132 | 2395132 | 2022-04-10 | New Kent | Virginia | 51127 | 4616 | 32 |
2391829 | 2391829 | 2022-04-09 | Essex | Virginia | 51057 | 2257 | 32 |
2391876 | 2391876 | 2022-04-09 | New Kent | Virginia | 51127 | 4616 | 32 |
2388573 | 2388573 | 2022-04-08 | Essex | Virginia | 51057 | 2257 | 32 |
2388620 | 2388620 | 2022-04-08 | New Kent | Virginia | 51127 | 4616 | 32 |
2385318 | 2385318 | 2022-04-07 | Essex | Virginia | 51057 | 2257 | 32 |
2385365 | 2385365 | 2022-04-07 | New Kent | Virginia | 51127 | 4615 | 32 |
2382063 | 2382063 | 2022-04-06 | Essex | Virginia | 51057 | 2256 | 32 |
2382110 | 2382110 | 2022-04-06 | New Kent | Virginia | 51127 | 4613 | 32 |
2378808 | 2378808 | 2022-04-05 | Essex | Virginia | 51057 | 2256 | 32 |
2378855 | 2378855 | 2022-04-05 | New Kent | Virginia | 51127 | 4611 | 32 |
2375554 | 2375554 | 2022-04-04 | Essex | Virginia | 51057 | 2256 | 32 |
2375600 | 2375600 | 2022-04-04 | Nelson | Virginia | 51125 | 2610 | 32 |
2375601 | 2375601 | 2022-04-04 | New Kent | Virginia | 51127 | 4610 | 32 |
2372302 | 2372302 | 2022-04-03 | Essex | Virginia | 51057 | 2256 | 32 |
2372348 | 2372348 | 2022-04-03 | Nelson | Virginia | 51125 | 2628 | 32 |
2372349 | 2372349 | 2022-04-03 | New Kent | Virginia | 51127 | 4607 | 32 |
2369049 | 2369049 | 2022-04-02 | Essex | Virginia | 51057 | 2256 | 32 |
2369095 | 2369095 | 2022-04-02 | Nelson | Virginia | 51125 | 2628 | 32 |
2369096 | 2369096 | 2022-04-02 | New Kent | Virginia | 51127 | 4607 | 32 |
2365796 | 2365796 | 2022-04-01 | Essex | Virginia | 51057 | 2256 | 32 |
2365842 | 2365842 | 2022-04-01 | Nelson | Virginia | 51125 | 2628 | 32 |
2365843 | 2365843 | 2022-04-01 | New Kent | Virginia | 51127 | 4607 | 32 |
2362543 | 2362543 | 2022-03-31 | Essex | Virginia | 51057 | 2256 | 32 |
2362589 | 2362589 | 2022-03-31 | Nelson | Virginia | 51125 | 2657 | 32 |
2362590 | 2362590 | 2022-03-31 | New Kent | Virginia | 51127 | 4606 | 32 |
2359289 | 2359289 | 2022-03-30 | Essex | Virginia | 51057 | 2256 | 32 |
2359335 | 2359335 | 2022-03-30 | Nelson | Virginia | 51125 | 2681 | 32 |
2359336 | 2359336 | 2022-03-30 | New Kent | Virginia | 51127 | 4606 | 32 |
2356035 | 2356035 | 2022-03-29 | Essex | Virginia | 51057 | 2256 | 32 |
2356082 | 2356082 | 2022-03-29 | New Kent | Virginia | 51127 | 4604 | 32 |
2352782 | 2352782 | 2022-03-28 | Essex | Virginia | 51057 | 2256 | 32 |
2352829 | 2352829 | 2022-03-28 | New Kent | Virginia | 51127 | 4598 | 32 |
2349530 | 2349530 | 2022-03-27 | Essex | Virginia | 51057 | 2255 | 32 |
2349577 | 2349577 | 2022-03-27 | New Kent | Virginia | 51127 | 4591 | 32 |
2346277 | 2346277 | 2022-03-26 | Essex | Virginia | 51057 | 2255 | 32 |
2346324 | 2346324 | 2022-03-26 | New Kent | Virginia | 51127 | 4591 | 32 |
2343024 | 2343024 | 2022-03-25 | Essex | Virginia | 51057 | 2255 | 32 |
2343071 | 2343071 | 2022-03-25 | New Kent | Virginia | 51127 | 4591 | 32 |
2339771 | 2339771 | 2022-03-24 | Essex | Virginia | 51057 | 2255 | 32 |
2339818 | 2339818 | 2022-03-24 | New Kent | Virginia | 51127 | 4587 | 32 |
2336517 | 2336517 | 2022-03-23 | Essex | Virginia | 51057 | 2255 | 32 |
2336564 | 2336564 | 2022-03-23 | New Kent | Virginia | 51127 | 4576 | 32 |
2333310 | 2333310 | 2022-03-22 | New Kent | Virginia | 51127 | 4574 | 32 |
2330057 | 2330057 | 2022-03-21 | New Kent | Virginia | 51127 | 4574 | 32 |
2326804 | 2326804 | 2022-03-20 | Nelson | Virginia | 51125 | 2687 | 32 |
2326805 | 2326805 | 2022-03-20 | New Kent | Virginia | 51127 | 4573 | 32 |
2323551 | 2323551 | 2022-03-19 | Nelson | Virginia | 51125 | 2687 | 32 |
2323552 | 2323552 | 2022-03-19 | New Kent | Virginia | 51127 | 4573 | 32 |
2320297 | 2320297 | 2022-03-18 | Nelson | Virginia | 51125 | 2687 | 32 |
2320298 | 2320298 | 2022-03-18 | New Kent | Virginia | 51127 | 4573 | 32 |
2317043 | 2317043 | 2022-03-17 | Nelson | Virginia | 51125 | 2685 | 32 |
2317044 | 2317044 | 2022-03-17 | New Kent | Virginia | 51127 | 4573 | 32 |
2313790 | 2313790 | 2022-03-16 | Nelson | Virginia | 51125 | 2683 | 32 |
2313791 | 2313791 | 2022-03-16 | New Kent | Virginia | 51127 | 4576 | 32 |
2310537 | 2310537 | 2022-03-15 | Nelson | Virginia | 51125 | 2688 | 32 |
2310538 | 2310538 | 2022-03-15 | New Kent | Virginia | 51127 | 4576 | 32 |
2307284 | 2307284 | 2022-03-14 | Nelson | Virginia | 51125 | 2688 | 32 |
2307285 | 2307285 | 2022-03-14 | New Kent | Virginia | 51127 | 4573 | 32 |
2304033 | 2304033 | 2022-03-13 | Nelson | Virginia | 51125 | 2684 | 32 |
2304034 | 2304034 | 2022-03-13 | New Kent | Virginia | 51127 | 4564 | 32 |
2300781 | 2300781 | 2022-03-12 | Nelson | Virginia | 51125 | 2684 | 32 |
2300782 | 2300782 | 2022-03-12 | New Kent | Virginia | 51127 | 4564 | 32 |
2297529 | 2297529 | 2022-03-11 | Nelson | Virginia | 51125 | 2684 | 32 |
2297530 | 2297530 | 2022-03-11 | New Kent | Virginia | 51127 | 4564 | 32 |
2294277 | 2294277 | 2022-03-10 | Nelson | Virginia | 51125 | 2684 | 32 |
2294278 | 2294278 | 2022-03-10 | New Kent | Virginia | 51127 | 4563 | 32 |
2291025 | 2291025 | 2022-03-09 | Nelson | Virginia | 51125 | 2684 | 32 |
2291026 | 2291026 | 2022-03-09 | New Kent | Virginia | 51127 | 4562 | 32 |
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);