ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 51135 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502599 | 2502599 | 2022-05-13 | Nottoway | Virginia | 51135 | 4300 | 92 |
2499341 | 2499341 | 2022-05-12 | Nottoway | Virginia | 51135 | 4297 | 92 |
2496083 | 2496083 | 2022-05-11 | Nottoway | Virginia | 51135 | 4299 | 92 |
2492825 | 2492825 | 2022-05-10 | Nottoway | Virginia | 51135 | 4293 | 92 |
2489567 | 2489567 | 2022-05-09 | Nottoway | Virginia | 51135 | 4289 | 92 |
2486310 | 2486310 | 2022-05-08 | Nottoway | Virginia | 51135 | 4283 | 92 |
2483052 | 2483052 | 2022-05-07 | Nottoway | Virginia | 51135 | 4283 | 92 |
2479794 | 2479794 | 2022-05-06 | Nottoway | Virginia | 51135 | 4283 | 92 |
2476536 | 2476536 | 2022-05-05 | Nottoway | Virginia | 51135 | 4269 | 91 |
2473278 | 2473278 | 2022-05-04 | Nottoway | Virginia | 51135 | 4264 | 91 |
2470022 | 2470022 | 2022-05-03 | Nottoway | Virginia | 51135 | 4254 | 91 |
2466766 | 2466766 | 2022-05-02 | Nottoway | Virginia | 51135 | 4257 | 91 |
2463511 | 2463511 | 2022-05-01 | Nottoway | Virginia | 51135 | 4248 | 91 |
2460255 | 2460255 | 2022-04-30 | Nottoway | Virginia | 51135 | 4248 | 91 |
2456999 | 2456999 | 2022-04-29 | Nottoway | Virginia | 51135 | 4248 | 91 |
2453743 | 2453743 | 2022-04-28 | Nottoway | Virginia | 51135 | 4246 | 90 |
2450487 | 2450487 | 2022-04-27 | Nottoway | Virginia | 51135 | 4245 | 90 |
2447230 | 2447230 | 2022-04-26 | Nottoway | Virginia | 51135 | 4242 | 90 |
2443975 | 2443975 | 2022-04-25 | Nottoway | Virginia | 51135 | 4238 | 90 |
2440719 | 2440719 | 2022-04-24 | Nottoway | Virginia | 51135 | 4228 | 90 |
2437463 | 2437463 | 2022-04-23 | Nottoway | Virginia | 51135 | 4228 | 90 |
2434207 | 2434207 | 2022-04-22 | Nottoway | Virginia | 51135 | 4228 | 90 |
2430951 | 2430951 | 2022-04-21 | Nottoway | Virginia | 51135 | 4224 | 90 |
2427695 | 2427695 | 2022-04-20 | Nottoway | Virginia | 51135 | 4218 | 90 |
2424439 | 2424439 | 2022-04-19 | Nottoway | Virginia | 51135 | 4219 | 90 |
2421183 | 2421183 | 2022-04-18 | Nottoway | Virginia | 51135 | 4213 | 90 |
2417927 | 2417927 | 2022-04-17 | Nottoway | Virginia | 51135 | 4207 | 89 |
2414671 | 2414671 | 2022-04-16 | Nottoway | Virginia | 51135 | 4207 | 89 |
2411415 | 2411415 | 2022-04-15 | Nottoway | Virginia | 51135 | 4207 | 89 |
2408159 | 2408159 | 2022-04-14 | Nottoway | Virginia | 51135 | 4202 | 88 |
2404903 | 2404903 | 2022-04-13 | Nottoway | Virginia | 51135 | 4203 | 88 |
2401648 | 2401648 | 2022-04-12 | Nottoway | Virginia | 51135 | 4195 | 88 |
2398393 | 2398393 | 2022-04-11 | Nottoway | Virginia | 51135 | 4143 | 88 |
2395138 | 2395138 | 2022-04-10 | Nottoway | Virginia | 51135 | 4120 | 88 |
2391882 | 2391882 | 2022-04-09 | Nottoway | Virginia | 51135 | 4120 | 88 |
2388626 | 2388626 | 2022-04-08 | Nottoway | Virginia | 51135 | 4120 | 88 |
2385371 | 2385371 | 2022-04-07 | Nottoway | Virginia | 51135 | 4121 | 87 |
2382116 | 2382116 | 2022-04-06 | Nottoway | Virginia | 51135 | 4118 | 87 |
2378861 | 2378861 | 2022-04-05 | Nottoway | Virginia | 51135 | 4083 | 87 |
2375607 | 2375607 | 2022-04-04 | Nottoway | Virginia | 51135 | 4079 | 87 |
2372355 | 2372355 | 2022-04-03 | Nottoway | Virginia | 51135 | 4072 | 87 |
2369102 | 2369102 | 2022-04-02 | Nottoway | Virginia | 51135 | 4072 | 87 |
2365849 | 2365849 | 2022-04-01 | Nottoway | Virginia | 51135 | 4072 | 87 |
2362596 | 2362596 | 2022-03-31 | Nottoway | Virginia | 51135 | 4069 | 87 |
2359342 | 2359342 | 2022-03-30 | Nottoway | Virginia | 51135 | 4067 | 87 |
2356088 | 2356088 | 2022-03-29 | Nottoway | Virginia | 51135 | 4061 | 87 |
2352835 | 2352835 | 2022-03-28 | Nottoway | Virginia | 51135 | 4058 | 87 |
2349583 | 2349583 | 2022-03-27 | Nottoway | Virginia | 51135 | 4053 | 87 |
2346330 | 2346330 | 2022-03-26 | Nottoway | Virginia | 51135 | 4053 | 87 |
2343077 | 2343077 | 2022-03-25 | Nottoway | Virginia | 51135 | 4053 | 87 |
2339824 | 2339824 | 2022-03-24 | Nottoway | Virginia | 51135 | 4047 | 87 |
2336570 | 2336570 | 2022-03-23 | Nottoway | Virginia | 51135 | 4045 | 87 |
2333316 | 2333316 | 2022-03-22 | Nottoway | Virginia | 51135 | 4029 | 87 |
2330063 | 2330063 | 2022-03-21 | Nottoway | Virginia | 51135 | 4029 | 87 |
2326811 | 2326811 | 2022-03-20 | Nottoway | Virginia | 51135 | 4010 | 87 |
2323558 | 2323558 | 2022-03-19 | Nottoway | Virginia | 51135 | 4010 | 87 |
2320304 | 2320304 | 2022-03-18 | Nottoway | Virginia | 51135 | 4010 | 87 |
2317050 | 2317050 | 2022-03-17 | Nottoway | Virginia | 51135 | 4007 | 87 |
2313797 | 2313797 | 2022-03-16 | Nottoway | Virginia | 51135 | 4005 | 87 |
2310544 | 2310544 | 2022-03-15 | Nottoway | Virginia | 51135 | 4004 | 87 |
2307291 | 2307291 | 2022-03-14 | Nottoway | Virginia | 51135 | 3982 | 86 |
2304040 | 2304040 | 2022-03-13 | Nottoway | Virginia | 51135 | 3977 | 85 |
2300788 | 2300788 | 2022-03-12 | Nottoway | Virginia | 51135 | 3977 | 85 |
2297536 | 2297536 | 2022-03-11 | Nottoway | Virginia | 51135 | 3977 | 85 |
2294284 | 2294284 | 2022-03-10 | Nottoway | Virginia | 51135 | 3975 | 85 |
2291032 | 2291032 | 2022-03-09 | Nottoway | Virginia | 51135 | 3973 | 85 |
2287780 | 2287780 | 2022-03-08 | Nottoway | Virginia | 51135 | 3971 | 85 |
2284528 | 2284528 | 2022-03-07 | Nottoway | Virginia | 51135 | 3964 | 85 |
2281276 | 2281276 | 2022-03-06 | Nottoway | Virginia | 51135 | 3962 | 84 |
2278023 | 2278023 | 2022-03-05 | Nottoway | Virginia | 51135 | 3962 | 84 |
2274770 | 2274770 | 2022-03-04 | Nottoway | Virginia | 51135 | 3962 | 84 |
2271517 | 2271517 | 2022-03-03 | Nottoway | Virginia | 51135 | 3960 | 83 |
2268265 | 2268265 | 2022-03-02 | Nottoway | Virginia | 51135 | 3956 | 83 |
2265012 | 2265012 | 2022-03-01 | Nottoway | Virginia | 51135 | 3951 | 83 |
2261762 | 2261762 | 2022-02-28 | Nottoway | Virginia | 51135 | 3937 | 83 |
2258511 | 2258511 | 2022-02-27 | Nottoway | Virginia | 51135 | 3934 | 82 |
2255260 | 2255260 | 2022-02-26 | Nottoway | Virginia | 51135 | 3934 | 82 |
2252009 | 2252009 | 2022-02-25 | Nottoway | Virginia | 51135 | 3934 | 82 |
2248758 | 2248758 | 2022-02-24 | Nottoway | Virginia | 51135 | 3927 | 80 |
2245507 | 2245507 | 2022-02-23 | Nottoway | Virginia | 51135 | 3923 | 80 |
2242256 | 2242256 | 2022-02-22 | Nottoway | Virginia | 51135 | 3916 | 80 |
2239005 | 2239005 | 2022-02-21 | Nottoway | Virginia | 51135 | 3913 | 80 |
2235754 | 2235754 | 2022-02-20 | Nottoway | Virginia | 51135 | 3901 | 79 |
2232503 | 2232503 | 2022-02-19 | Nottoway | Virginia | 51135 | 3901 | 79 |
2229252 | 2229252 | 2022-02-18 | Nottoway | Virginia | 51135 | 3901 | 79 |
2226001 | 2226001 | 2022-02-17 | Nottoway | Virginia | 51135 | 3871 | 79 |
2222750 | 2222750 | 2022-02-16 | Nottoway | Virginia | 51135 | 3860 | 79 |
2219499 | 2219499 | 2022-02-15 | Nottoway | Virginia | 51135 | 3857 | 78 |
2216249 | 2216249 | 2022-02-14 | Nottoway | Virginia | 51135 | 3853 | 78 |
2212998 | 2212998 | 2022-02-13 | Nottoway | Virginia | 51135 | 3836 | 76 |
2209745 | 2209745 | 2022-02-12 | Nottoway | Virginia | 51135 | 3836 | 76 |
2206492 | 2206492 | 2022-02-11 | Nottoway | Virginia | 51135 | 3836 | 76 |
2203239 | 2203239 | 2022-02-10 | Nottoway | Virginia | 51135 | 3825 | 76 |
2199985 | 2199985 | 2022-02-09 | Nottoway | Virginia | 51135 | 3811 | 75 |
2196731 | 2196731 | 2022-02-08 | Nottoway | Virginia | 51135 | 3794 | 75 |
2193476 | 2193476 | 2022-02-07 | Nottoway | Virginia | 51135 | 3753 | 75 |
2190223 | 2190223 | 2022-02-06 | Nottoway | Virginia | 51135 | 3728 | 75 |
2186970 | 2186970 | 2022-02-05 | Nottoway | Virginia | 51135 | 3728 | 75 |
2183717 | 2183717 | 2022-02-04 | Nottoway | Virginia | 51135 | 3728 | 75 |
2180465 | 2180465 | 2022-02-03 | Nottoway | Virginia | 51135 | 3711 | 74 |
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);