ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
746 rows where fips = 51690 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502587 | 2502587 | 2022-05-13 | Martinsville city | Virginia | 51690 | 3478 | 124 |
2499329 | 2499329 | 2022-05-12 | Martinsville city | Virginia | 51690 | 3466 | 124 |
2496071 | 2496071 | 2022-05-11 | Martinsville city | Virginia | 51690 | 3465 | 124 |
2492813 | 2492813 | 2022-05-10 | Martinsville city | Virginia | 51690 | 3463 | 124 |
2489555 | 2489555 | 2022-05-09 | Martinsville city | Virginia | 51690 | 3464 | 124 |
2486298 | 2486298 | 2022-05-08 | Martinsville city | Virginia | 51690 | 3457 | 124 |
2483040 | 2483040 | 2022-05-07 | Martinsville city | Virginia | 51690 | 3457 | 124 |
2479782 | 2479782 | 2022-05-06 | Martinsville city | Virginia | 51690 | 3457 | 124 |
2476524 | 2476524 | 2022-05-05 | Martinsville city | Virginia | 51690 | 3452 | 124 |
2473266 | 2473266 | 2022-05-04 | Martinsville city | Virginia | 51690 | 3451 | 123 |
2470010 | 2470010 | 2022-05-03 | Martinsville city | Virginia | 51690 | 3448 | 123 |
2466754 | 2466754 | 2022-05-02 | Martinsville city | Virginia | 51690 | 3445 | 123 |
2463499 | 2463499 | 2022-05-01 | Martinsville city | Virginia | 51690 | 3439 | 123 |
2460243 | 2460243 | 2022-04-30 | Martinsville city | Virginia | 51690 | 3439 | 123 |
2456987 | 2456987 | 2022-04-29 | Martinsville city | Virginia | 51690 | 3439 | 123 |
2453731 | 2453731 | 2022-04-28 | Martinsville city | Virginia | 51690 | 3434 | 123 |
2450475 | 2450475 | 2022-04-27 | Martinsville city | Virginia | 51690 | 3424 | 123 |
2447218 | 2447218 | 2022-04-26 | Martinsville city | Virginia | 51690 | 3415 | 123 |
2443963 | 2443963 | 2022-04-25 | Martinsville city | Virginia | 51690 | 3412 | 122 |
2440707 | 2440707 | 2022-04-24 | Martinsville city | Virginia | 51690 | 3384 | 121 |
2437451 | 2437451 | 2022-04-23 | Martinsville city | Virginia | 51690 | 3384 | 121 |
2434195 | 2434195 | 2022-04-22 | Martinsville city | Virginia | 51690 | 3384 | 121 |
2430939 | 2430939 | 2022-04-21 | Martinsville city | Virginia | 51690 | 3368 | 119 |
2427683 | 2427683 | 2022-04-20 | Martinsville city | Virginia | 51690 | 3363 | 119 |
2424427 | 2424427 | 2022-04-19 | Martinsville city | Virginia | 51690 | 3359 | 119 |
2421171 | 2421171 | 2022-04-18 | Martinsville city | Virginia | 51690 | 3358 | 118 |
2417915 | 2417915 | 2022-04-17 | Martinsville city | Virginia | 51690 | 3353 | 118 |
2414659 | 2414659 | 2022-04-16 | Martinsville city | Virginia | 51690 | 3353 | 118 |
2411403 | 2411403 | 2022-04-15 | Martinsville city | Virginia | 51690 | 3353 | 118 |
2408147 | 2408147 | 2022-04-14 | Martinsville city | Virginia | 51690 | 3349 | 118 |
2404891 | 2404891 | 2022-04-13 | Martinsville city | Virginia | 51690 | 3345 | 117 |
2401636 | 2401636 | 2022-04-12 | Martinsville city | Virginia | 51690 | 3341 | 117 |
2398381 | 2398381 | 2022-04-11 | Martinsville city | Virginia | 51690 | 3332 | 117 |
2395126 | 2395126 | 2022-04-10 | Martinsville city | Virginia | 51690 | 3326 | 117 |
2391870 | 2391870 | 2022-04-09 | Martinsville city | Virginia | 51690 | 3326 | 117 |
2388614 | 2388614 | 2022-04-08 | Martinsville city | Virginia | 51690 | 3326 | 117 |
2385359 | 2385359 | 2022-04-07 | Martinsville city | Virginia | 51690 | 3323 | 117 |
2382104 | 2382104 | 2022-04-06 | Martinsville city | Virginia | 51690 | 3315 | 117 |
2378849 | 2378849 | 2022-04-05 | Martinsville city | Virginia | 51690 | 3312 | 117 |
2375595 | 2375595 | 2022-04-04 | Martinsville city | Virginia | 51690 | 3312 | 115 |
2372343 | 2372343 | 2022-04-03 | Martinsville city | Virginia | 51690 | 3306 | 115 |
2369090 | 2369090 | 2022-04-02 | Martinsville city | Virginia | 51690 | 3306 | 115 |
2365837 | 2365837 | 2022-04-01 | Martinsville city | Virginia | 51690 | 3306 | 115 |
2362584 | 2362584 | 2022-03-31 | Martinsville city | Virginia | 51690 | 3306 | 115 |
2359330 | 2359330 | 2022-03-30 | Martinsville city | Virginia | 51690 | 3300 | 115 |
2356076 | 2356076 | 2022-03-29 | Martinsville city | Virginia | 51690 | 3300 | 115 |
2352823 | 2352823 | 2022-03-28 | Martinsville city | Virginia | 51690 | 3293 | 115 |
2349571 | 2349571 | 2022-03-27 | Martinsville city | Virginia | 51690 | 3292 | 115 |
2346318 | 2346318 | 2022-03-26 | Martinsville city | Virginia | 51690 | 3292 | 115 |
2343065 | 2343065 | 2022-03-25 | Martinsville city | Virginia | 51690 | 3292 | 115 |
2339812 | 2339812 | 2022-03-24 | Martinsville city | Virginia | 51690 | 3286 | 115 |
2336558 | 2336558 | 2022-03-23 | Martinsville city | Virginia | 51690 | 3281 | 114 |
2333304 | 2333304 | 2022-03-22 | Martinsville city | Virginia | 51690 | 3276 | 115 |
2330051 | 2330051 | 2022-03-21 | Martinsville city | Virginia | 51690 | 3276 | 115 |
2326799 | 2326799 | 2022-03-20 | Martinsville city | Virginia | 51690 | 3251 | 114 |
2323546 | 2323546 | 2022-03-19 | Martinsville city | Virginia | 51690 | 3251 | 114 |
2320292 | 2320292 | 2022-03-18 | Martinsville city | Virginia | 51690 | 3251 | 114 |
2317038 | 2317038 | 2022-03-17 | Martinsville city | Virginia | 51690 | 3240 | 114 |
2313785 | 2313785 | 2022-03-16 | Martinsville city | Virginia | 51690 | 3220 | 114 |
2310532 | 2310532 | 2022-03-15 | Martinsville city | Virginia | 51690 | 3203 | 114 |
2307279 | 2307279 | 2022-03-14 | Martinsville city | Virginia | 51690 | 3197 | 113 |
2304028 | 2304028 | 2022-03-13 | Martinsville city | Virginia | 51690 | 3195 | 113 |
2300776 | 2300776 | 2022-03-12 | Martinsville city | Virginia | 51690 | 3195 | 113 |
2297524 | 2297524 | 2022-03-11 | Martinsville city | Virginia | 51690 | 3195 | 113 |
2294272 | 2294272 | 2022-03-10 | Martinsville city | Virginia | 51690 | 3188 | 113 |
2291020 | 2291020 | 2022-03-09 | Martinsville city | Virginia | 51690 | 3181 | 113 |
2287768 | 2287768 | 2022-03-08 | Martinsville city | Virginia | 51690 | 3178 | 113 |
2284516 | 2284516 | 2022-03-07 | Martinsville city | Virginia | 51690 | 3178 | 112 |
2281264 | 2281264 | 2022-03-06 | Martinsville city | Virginia | 51690 | 3172 | 112 |
2278011 | 2278011 | 2022-03-05 | Martinsville city | Virginia | 51690 | 3172 | 112 |
2274758 | 2274758 | 2022-03-04 | Martinsville city | Virginia | 51690 | 3172 | 112 |
2271505 | 2271505 | 2022-03-03 | Martinsville city | Virginia | 51690 | 3172 | 112 |
2268253 | 2268253 | 2022-03-02 | Martinsville city | Virginia | 51690 | 3172 | 111 |
2265000 | 2265000 | 2022-03-01 | Martinsville city | Virginia | 51690 | 3173 | 111 |
2261750 | 2261750 | 2022-02-28 | Martinsville city | Virginia | 51690 | 3171 | 110 |
2258499 | 2258499 | 2022-02-27 | Martinsville city | Virginia | 51690 | 3170 | 110 |
2255248 | 2255248 | 2022-02-26 | Martinsville city | Virginia | 51690 | 3170 | 110 |
2251997 | 2251997 | 2022-02-25 | Martinsville city | Virginia | 51690 | 3170 | 110 |
2248746 | 2248746 | 2022-02-24 | Martinsville city | Virginia | 51690 | 3166 | 110 |
2245495 | 2245495 | 2022-02-23 | Martinsville city | Virginia | 51690 | 3164 | 109 |
2242244 | 2242244 | 2022-02-22 | Martinsville city | Virginia | 51690 | 3163 | 108 |
2238993 | 2238993 | 2022-02-21 | Martinsville city | Virginia | 51690 | 3162 | 108 |
2235742 | 2235742 | 2022-02-20 | Martinsville city | Virginia | 51690 | 3119 | 108 |
2232491 | 2232491 | 2022-02-19 | Martinsville city | Virginia | 51690 | 3119 | 108 |
2229240 | 2229240 | 2022-02-18 | Martinsville city | Virginia | 51690 | 3119 | 108 |
2225989 | 2225989 | 2022-02-17 | Martinsville city | Virginia | 51690 | 3106 | 108 |
2222738 | 2222738 | 2022-02-16 | Martinsville city | Virginia | 51690 | 3093 | 107 |
2219487 | 2219487 | 2022-02-15 | Martinsville city | Virginia | 51690 | 3072 | 107 |
2216237 | 2216237 | 2022-02-14 | Martinsville city | Virginia | 51690 | 3041 | 107 |
2212986 | 2212986 | 2022-02-13 | Martinsville city | Virginia | 51690 | 2999 | 107 |
2209733 | 2209733 | 2022-02-12 | Martinsville city | Virginia | 51690 | 2999 | 107 |
2206480 | 2206480 | 2022-02-11 | Martinsville city | Virginia | 51690 | 2999 | 107 |
2203227 | 2203227 | 2022-02-10 | Martinsville city | Virginia | 51690 | 2996 | 107 |
2199973 | 2199973 | 2022-02-09 | Martinsville city | Virginia | 51690 | 2990 | 106 |
2196719 | 2196719 | 2022-02-08 | Martinsville city | Virginia | 51690 | 2986 | 104 |
2193464 | 2193464 | 2022-02-07 | Martinsville city | Virginia | 51690 | 2983 | 104 |
2190211 | 2190211 | 2022-02-06 | Martinsville city | Virginia | 51690 | 2960 | 103 |
2186958 | 2186958 | 2022-02-05 | Martinsville city | Virginia | 51690 | 2960 | 103 |
2183705 | 2183705 | 2022-02-04 | Martinsville city | Virginia | 51690 | 2960 | 103 |
2180453 | 2180453 | 2022-02-03 | Martinsville city | Virginia | 51690 | 2946 | 103 |
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);