ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,591 rows where county = "El Paso" 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 |
---|---|---|---|---|---|---|---|
2499840 | 2499840 | 2022-05-13 | El Paso | Colorado | 8041 | 190541 | 1695 |
2502276 | 2502276 | 2022-05-13 | El Paso | Texas | 48141 | 208635 | 3734 |
2496582 | 2496582 | 2022-05-12 | El Paso | Colorado | 8041 | 190329 | 1694 |
2499018 | 2499018 | 2022-05-12 | El Paso | Texas | 48141 | 208559 | 3735 |
2493324 | 2493324 | 2022-05-11 | El Paso | Colorado | 8041 | 188797 | 1694 |
2495760 | 2495760 | 2022-05-11 | El Paso | Texas | 48141 | 208420 | 3735 |
2490066 | 2490066 | 2022-05-10 | El Paso | Colorado | 8041 | 188684 | 1694 |
2492502 | 2492502 | 2022-05-10 | El Paso | Texas | 48141 | 208400 | 3735 |
2486809 | 2486809 | 2022-05-09 | El Paso | Colorado | 8041 | 188527 | 1695 |
2489244 | 2489244 | 2022-05-09 | El Paso | Texas | 48141 | 208370 | 3734 |
2483551 | 2483551 | 2022-05-08 | El Paso | Colorado | 8041 | 188257 | 1695 |
2485987 | 2485987 | 2022-05-08 | El Paso | Texas | 48141 | 208323 | 3734 |
2480293 | 2480293 | 2022-05-07 | El Paso | Colorado | 8041 | 188257 | 1695 |
2482729 | 2482729 | 2022-05-07 | El Paso | Texas | 48141 | 208270 | 3733 |
2477035 | 2477035 | 2022-05-06 | El Paso | Colorado | 8041 | 188257 | 1695 |
2479471 | 2479471 | 2022-05-06 | El Paso | Texas | 48141 | 208190 | 3733 |
2473777 | 2473777 | 2022-05-05 | El Paso | Colorado | 8041 | 188118 | 1695 |
2476213 | 2476213 | 2022-05-05 | El Paso | Texas | 48141 | 208151 | 3732 |
2470520 | 2470520 | 2022-05-04 | El Paso | Colorado | 8041 | 187952 | 1689 |
2472956 | 2472956 | 2022-05-04 | El Paso | Texas | 48141 | 208117 | 3730 |
2467264 | 2467264 | 2022-05-03 | El Paso | Colorado | 8041 | 187865 | 1688 |
2469700 | 2469700 | 2022-05-03 | El Paso | Texas | 48141 | 208095 | 3729 |
2464009 | 2464009 | 2022-05-02 | El Paso | Colorado | 8041 | 187726 | 1645 |
2466444 | 2466444 | 2022-05-02 | El Paso | Texas | 48141 | 208067 | 3729 |
2460753 | 2460753 | 2022-05-01 | El Paso | Colorado | 8041 | 187540 | 1643 |
2463189 | 2463189 | 2022-05-01 | El Paso | Texas | 48141 | 208037 | 3728 |
2457497 | 2457497 | 2022-04-30 | El Paso | Colorado | 8041 | 187540 | 1643 |
2459933 | 2459933 | 2022-04-30 | El Paso | Texas | 48141 | 208001 | 3728 |
2454241 | 2454241 | 2022-04-29 | El Paso | Colorado | 8041 | 187540 | 1643 |
2456677 | 2456677 | 2022-04-29 | El Paso | Texas | 48141 | 207954 | 3728 |
2450985 | 2450985 | 2022-04-28 | El Paso | Colorado | 8041 | 187446 | 1642 |
2453421 | 2453421 | 2022-04-28 | El Paso | Texas | 48141 | 207925 | 3726 |
2447729 | 2447729 | 2022-04-27 | El Paso | Colorado | 8041 | 187338 | 1642 |
2450165 | 2450165 | 2022-04-27 | El Paso | Texas | 48141 | 207883 | 3725 |
2444473 | 2444473 | 2022-04-26 | El Paso | Colorado | 8041 | 187160 | 1639 |
2446908 | 2446908 | 2022-04-26 | El Paso | Texas | 48141 | 207859 | 3724 |
2441217 | 2441217 | 2022-04-25 | El Paso | Colorado | 8041 | 186995 | 1632 |
2443653 | 2443653 | 2022-04-25 | El Paso | Texas | 48141 | 207844 | 3724 |
2437961 | 2437961 | 2022-04-24 | El Paso | Colorado | 8041 | 186634 | 1626 |
2440397 | 2440397 | 2022-04-24 | El Paso | Texas | 48141 | 207831 | 3724 |
2434705 | 2434705 | 2022-04-23 | El Paso | Colorado | 8041 | 186634 | 1626 |
2437141 | 2437141 | 2022-04-23 | El Paso | Texas | 48141 | 207799 | 3724 |
2431449 | 2431449 | 2022-04-22 | El Paso | Colorado | 8041 | 186634 | 1626 |
2433885 | 2433885 | 2022-04-22 | El Paso | Texas | 48141 | 207756 | 3724 |
2428193 | 2428193 | 2022-04-21 | El Paso | Colorado | 8041 | 186395 | 1621 |
2430629 | 2430629 | 2022-04-21 | El Paso | Texas | 48141 | 207721 | 3722 |
2424937 | 2424937 | 2022-04-20 | El Paso | Colorado | 8041 | 186140 | 1615 |
2427373 | 2427373 | 2022-04-20 | El Paso | Texas | 48141 | 207694 | 3722 |
2421681 | 2421681 | 2022-04-19 | El Paso | Colorado | 8041 | 185904 | 1615 |
2424117 | 2424117 | 2022-04-19 | El Paso | Texas | 48141 | 207675 | 3721 |
2418425 | 2418425 | 2022-04-18 | El Paso | Colorado | 8041 | 185711 | 1615 |
2420861 | 2420861 | 2022-04-18 | El Paso | Texas | 48141 | 207657 | 3720 |
2415169 | 2415169 | 2022-04-17 | El Paso | Colorado | 8041 | 185364 | 1614 |
2417605 | 2417605 | 2022-04-17 | El Paso | Texas | 48141 | 207545 | 3719 |
2411913 | 2411913 | 2022-04-16 | El Paso | Colorado | 8041 | 185364 | 1614 |
2414349 | 2414349 | 2022-04-16 | El Paso | Texas | 48141 | 207545 | 3719 |
2408657 | 2408657 | 2022-04-15 | El Paso | Colorado | 8041 | 185364 | 1614 |
2411093 | 2411093 | 2022-04-15 | El Paso | Texas | 48141 | 207545 | 3719 |
2405401 | 2405401 | 2022-04-14 | El Paso | Colorado | 8041 | 185172 | 1612 |
2407837 | 2407837 | 2022-04-14 | El Paso | Texas | 48141 | 207545 | 3719 |
2402146 | 2402146 | 2022-04-13 | El Paso | Colorado | 8041 | 184986 | 1612 |
2404581 | 2404581 | 2022-04-13 | El Paso | Texas | 48141 | 207520 | 3719 |
2398891 | 2398891 | 2022-04-12 | El Paso | Colorado | 8041 | 184799 | 1611 |
2401326 | 2401326 | 2022-04-12 | El Paso | Texas | 48141 | 207499 | 3719 |
2395636 | 2395636 | 2022-04-11 | El Paso | Colorado | 8041 | 184699 | 1611 |
2398071 | 2398071 | 2022-04-11 | El Paso | Texas | 48141 | 207478 | 3717 |
2392380 | 2392380 | 2022-04-10 | El Paso | Colorado | 8041 | 184390 | 1610 |
2394816 | 2394816 | 2022-04-10 | El Paso | Texas | 48141 | 207456 | 3717 |
2389124 | 2389124 | 2022-04-09 | El Paso | Colorado | 8041 | 184390 | 1610 |
2391560 | 2391560 | 2022-04-09 | El Paso | Texas | 48141 | 207437 | 3716 |
2385869 | 2385869 | 2022-04-08 | El Paso | Colorado | 8041 | 184390 | 1610 |
2388304 | 2388304 | 2022-04-08 | El Paso | Texas | 48141 | 207388 | 3715 |
2382614 | 2382614 | 2022-04-07 | El Paso | Colorado | 8041 | 184121 | 1610 |
2385049 | 2385049 | 2022-04-07 | El Paso | Texas | 48141 | 207377 | 3715 |
2379359 | 2379359 | 2022-04-06 | El Paso | Colorado | 8041 | 183980 | 1610 |
2381794 | 2381794 | 2022-04-06 | El Paso | Texas | 48141 | 207351 | 3712 |
2376105 | 2376105 | 2022-04-05 | El Paso | Colorado | 8041 | 183770 | 1610 |
2378539 | 2378539 | 2022-04-05 | El Paso | Texas | 48141 | 207335 | 3712 |
2372853 | 2372853 | 2022-04-04 | El Paso | Colorado | 8041 | 183581 | 1610 |
2375285 | 2375285 | 2022-04-04 | El Paso | Texas | 48141 | 207320 | 3712 |
2369600 | 2369600 | 2022-04-03 | El Paso | Colorado | 8041 | 183395 | 1610 |
2372033 | 2372033 | 2022-04-03 | El Paso | Texas | 48141 | 207294 | 3712 |
2366347 | 2366347 | 2022-04-02 | El Paso | Colorado | 8041 | 183395 | 1610 |
2368780 | 2368780 | 2022-04-02 | El Paso | Texas | 48141 | 207260 | 3712 |
2363094 | 2363094 | 2022-04-01 | El Paso | Colorado | 8041 | 183395 | 1610 |
2365527 | 2365527 | 2022-04-01 | El Paso | Texas | 48141 | 207226 | 3711 |
2359840 | 2359840 | 2022-03-31 | El Paso | Colorado | 8041 | 183152 | 1610 |
2362274 | 2362274 | 2022-03-31 | El Paso | Texas | 48141 | 207189 | 3710 |
2356586 | 2356586 | 2022-03-30 | El Paso | Colorado | 8041 | 182944 | 1610 |
2359020 | 2359020 | 2022-03-30 | El Paso | Texas | 48141 | 207145 | 3708 |
2353333 | 2353333 | 2022-03-29 | El Paso | Colorado | 8041 | 182671 | 1610 |
2355766 | 2355766 | 2022-03-29 | El Paso | Texas | 48141 | 207136 | 3708 |
2350081 | 2350081 | 2022-03-28 | El Paso | Colorado | 8041 | 182531 | 1609 |
2352513 | 2352513 | 2022-03-28 | El Paso | Texas | 48141 | 207096 | 3707 |
2346828 | 2346828 | 2022-03-27 | El Paso | Colorado | 8041 | 182333 | 1608 |
2349261 | 2349261 | 2022-03-27 | El Paso | Texas | 48141 | 207094 | 3706 |
2343575 | 2343575 | 2022-03-26 | El Paso | Colorado | 8041 | 182333 | 1608 |
2346008 | 2346008 | 2022-03-26 | El Paso | Texas | 48141 | 207083 | 3704 |
2340322 | 2340322 | 2022-03-25 | El Paso | Colorado | 8041 | 182333 | 1608 |
2342755 | 2342755 | 2022-03-25 | El Paso | Texas | 48141 | 207045 | 3703 |
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);