ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
746 rows where county = "Mariposa" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499783 | 2499783 | 2022-05-13 | Mariposa | California | 6043 | 3145 | 35 |
2496525 | 2496525 | 2022-05-12 | Mariposa | California | 6043 | 3142 | 35 |
2493267 | 2493267 | 2022-05-11 | Mariposa | California | 6043 | 3136 | 35 |
2490009 | 2490009 | 2022-05-10 | Mariposa | California | 6043 | 3126 | 34 |
2486752 | 2486752 | 2022-05-09 | Mariposa | California | 6043 | 3123 | 34 |
2483494 | 2483494 | 2022-05-08 | Mariposa | California | 6043 | 3101 | 34 |
2480236 | 2480236 | 2022-05-07 | Mariposa | California | 6043 | 3101 | 34 |
2476978 | 2476978 | 2022-05-06 | Mariposa | California | 6043 | 3101 | 34 |
2473720 | 2473720 | 2022-05-05 | Mariposa | California | 6043 | 3091 | 34 |
2470463 | 2470463 | 2022-05-04 | Mariposa | California | 6043 | 3085 | 34 |
2467207 | 2467207 | 2022-05-03 | Mariposa | California | 6043 | 3081 | 34 |
2463952 | 2463952 | 2022-05-02 | Mariposa | California | 6043 | 3081 | 34 |
2460696 | 2460696 | 2022-05-01 | Mariposa | California | 6043 | 3073 | 34 |
2457440 | 2457440 | 2022-04-30 | Mariposa | California | 6043 | 3073 | 34 |
2454184 | 2454184 | 2022-04-29 | Mariposa | California | 6043 | 3073 | 34 |
2450928 | 2450928 | 2022-04-28 | Mariposa | California | 6043 | 3066 | 34 |
2447672 | 2447672 | 2022-04-27 | Mariposa | California | 6043 | 3065 | 34 |
2444416 | 2444416 | 2022-04-26 | Mariposa | California | 6043 | 3065 | 34 |
2441160 | 2441160 | 2022-04-25 | Mariposa | California | 6043 | 3063 | 34 |
2437904 | 2437904 | 2022-04-24 | Mariposa | California | 6043 | 3060 | 34 |
2434648 | 2434648 | 2022-04-23 | Mariposa | California | 6043 | 3060 | 34 |
2431392 | 2431392 | 2022-04-22 | Mariposa | California | 6043 | 3060 | 34 |
2428136 | 2428136 | 2022-04-21 | Mariposa | California | 6043 | 3058 | 34 |
2424880 | 2424880 | 2022-04-20 | Mariposa | California | 6043 | 3053 | 34 |
2421624 | 2421624 | 2022-04-19 | Mariposa | California | 6043 | 3045 | 34 |
2418368 | 2418368 | 2022-04-18 | Mariposa | California | 6043 | 3045 | 34 |
2415112 | 2415112 | 2022-04-17 | Mariposa | California | 6043 | 3040 | 34 |
2411856 | 2411856 | 2022-04-16 | Mariposa | California | 6043 | 3040 | 34 |
2408600 | 2408600 | 2022-04-15 | Mariposa | California | 6043 | 3040 | 34 |
2405344 | 2405344 | 2022-04-14 | Mariposa | California | 6043 | 3040 | 34 |
2402089 | 2402089 | 2022-04-13 | Mariposa | California | 6043 | 3037 | 34 |
2398834 | 2398834 | 2022-04-12 | Mariposa | California | 6043 | 3031 | 34 |
2395579 | 2395579 | 2022-04-11 | Mariposa | California | 6043 | 3029 | 34 |
2392323 | 2392323 | 2022-04-10 | Mariposa | California | 6043 | 3026 | 34 |
2389067 | 2389067 | 2022-04-09 | Mariposa | California | 6043 | 3026 | 34 |
2385812 | 2385812 | 2022-04-08 | Mariposa | California | 6043 | 3026 | 34 |
2382557 | 2382557 | 2022-04-07 | Mariposa | California | 6043 | 3022 | 34 |
2379302 | 2379302 | 2022-04-06 | Mariposa | California | 6043 | 3020 | 34 |
2376048 | 2376048 | 2022-04-05 | Mariposa | California | 6043 | 3016 | 34 |
2372796 | 2372796 | 2022-04-04 | Mariposa | California | 6043 | 3015 | 33 |
2369543 | 2369543 | 2022-04-03 | Mariposa | California | 6043 | 3013 | 33 |
2366290 | 2366290 | 2022-04-02 | Mariposa | California | 6043 | 3013 | 33 |
2363037 | 2363037 | 2022-04-01 | Mariposa | California | 6043 | 3013 | 33 |
2359783 | 2359783 | 2022-03-31 | Mariposa | California | 6043 | 3013 | 33 |
2356529 | 2356529 | 2022-03-30 | Mariposa | California | 6043 | 3011 | 31 |
2353276 | 2353276 | 2022-03-29 | Mariposa | California | 6043 | 3008 | 30 |
2350024 | 2350024 | 2022-03-28 | Mariposa | California | 6043 | 3008 | 30 |
2346771 | 2346771 | 2022-03-27 | Mariposa | California | 6043 | 3007 | 30 |
2343518 | 2343518 | 2022-03-26 | Mariposa | California | 6043 | 3007 | 30 |
2340265 | 2340265 | 2022-03-25 | Mariposa | California | 6043 | 3007 | 30 |
2337012 | 2337012 | 2022-03-24 | Mariposa | California | 6043 | 3003 | 30 |
2333758 | 2333758 | 2022-03-23 | Mariposa | California | 6043 | 3001 | 30 |
2330504 | 2330504 | 2022-03-22 | Mariposa | California | 6043 | 3001 | 30 |
2327252 | 2327252 | 2022-03-21 | Mariposa | California | 6043 | 3001 | 30 |
2323999 | 2323999 | 2022-03-20 | Mariposa | California | 6043 | 2999 | 30 |
2320745 | 2320745 | 2022-03-19 | Mariposa | California | 6043 | 2999 | 30 |
2317491 | 2317491 | 2022-03-18 | Mariposa | California | 6043 | 2999 | 30 |
2314238 | 2314238 | 2022-03-17 | Mariposa | California | 6043 | 2996 | 30 |
2310985 | 2310985 | 2022-03-16 | Mariposa | California | 6043 | 2993 | 30 |
2307732 | 2307732 | 2022-03-15 | Mariposa | California | 6043 | 2991 | 30 |
2304481 | 2304481 | 2022-03-14 | Mariposa | California | 6043 | 2991 | 30 |
2301229 | 2301229 | 2022-03-13 | Mariposa | California | 6043 | 2985 | 30 |
2297977 | 2297977 | 2022-03-12 | Mariposa | California | 6043 | 2985 | 30 |
2294725 | 2294725 | 2022-03-11 | Mariposa | California | 6043 | 2985 | 30 |
2291473 | 2291473 | 2022-03-10 | Mariposa | California | 6043 | 2984 | 30 |
2288221 | 2288221 | 2022-03-09 | Mariposa | California | 6043 | 2983 | 30 |
2284970 | 2284970 | 2022-03-08 | Mariposa | California | 6043 | 2980 | 28 |
2281718 | 2281718 | 2022-03-07 | Mariposa | California | 6043 | 2978 | 26 |
2278465 | 2278465 | 2022-03-06 | Mariposa | California | 6043 | 2971 | 26 |
2275212 | 2275212 | 2022-03-05 | Mariposa | California | 6043 | 2971 | 26 |
2271959 | 2271959 | 2022-03-04 | Mariposa | California | 6043 | 2971 | 26 |
2268707 | 2268707 | 2022-03-03 | Mariposa | California | 6043 | 2971 | 26 |
2265454 | 2265454 | 2022-03-02 | Mariposa | California | 6043 | 2966 | 26 |
2262203 | 2262203 | 2022-03-01 | Mariposa | California | 6043 | 2960 | 20 |
2258952 | 2258952 | 2022-02-28 | Mariposa | California | 6043 | 2956 | 20 |
2255701 | 2255701 | 2022-02-27 | Mariposa | California | 6043 | 2938 | 20 |
2252450 | 2252450 | 2022-02-26 | Mariposa | California | 6043 | 2938 | 20 |
2249199 | 2249199 | 2022-02-25 | Mariposa | California | 6043 | 2938 | 20 |
2245948 | 2245948 | 2022-02-24 | Mariposa | California | 6043 | 2933 | 20 |
2242697 | 2242697 | 2022-02-23 | Mariposa | California | 6043 | 2929 | 20 |
2239446 | 2239446 | 2022-02-22 | Mariposa | California | 6043 | 2920 | 20 |
2236195 | 2236195 | 2022-02-21 | Mariposa | California | 6043 | 2907 | 20 |
2232944 | 2232944 | 2022-02-20 | Mariposa | California | 6043 | 2907 | 20 |
2229693 | 2229693 | 2022-02-19 | Mariposa | California | 6043 | 2907 | 20 |
2226442 | 2226442 | 2022-02-18 | Mariposa | California | 6043 | 2907 | 20 |
2223191 | 2223191 | 2022-02-17 | Mariposa | California | 6043 | 2903 | 20 |
2219940 | 2219940 | 2022-02-16 | Mariposa | California | 6043 | 2899 | 20 |
2216689 | 2216689 | 2022-02-15 | Mariposa | California | 6043 | 2894 | 20 |
2213438 | 2213438 | 2022-02-14 | Mariposa | California | 6043 | 2890 | 20 |
2210186 | 2210186 | 2022-02-13 | Mariposa | California | 6043 | 2877 | 20 |
2206933 | 2206933 | 2022-02-12 | Mariposa | California | 6043 | 2877 | 20 |
2203680 | 2203680 | 2022-02-11 | Mariposa | California | 6043 | 2877 | 20 |
2200427 | 2200427 | 2022-02-10 | Mariposa | California | 6043 | 2867 | 20 |
2197173 | 2197173 | 2022-02-09 | Mariposa | California | 6043 | 2852 | 20 |
2193918 | 2193918 | 2022-02-08 | Mariposa | California | 6043 | 2834 | 20 |
2190665 | 2190665 | 2022-02-07 | Mariposa | California | 6043 | 2823 | 20 |
2187412 | 2187412 | 2022-02-06 | Mariposa | California | 6043 | 2728 | 20 |
2184159 | 2184159 | 2022-02-05 | Mariposa | California | 6043 | 2728 | 20 |
2180907 | 2180907 | 2022-02-04 | Mariposa | California | 6043 | 2728 | 20 |
2177656 | 2177656 | 2022-02-03 | Mariposa | California | 6043 | 2717 | 20 |
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);