ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Hidalgo" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 445 ✖
- 10 19
- 0 14
- 3879 11
- 1 9
- 12 8
- 3 7
- 6 7
- 3504 7
- 11 6
- 3522 6
- 3600 6
- 4 5
- 2878 5
- 2911 5
- 3493 5
- 3528 5
- 3895 5
- 3908 5
- 7 4
- 8 4
- 1895 4
- 2030 4
- 2050 4
- 2090 4
- 2176 4
- 2201 4
- 2293 4
- 2549 4
- 2768 4
- 2801 4
- 2927 4
- 3138 4
- 3388 4
- 3514 4
- 3552 4
- 3750 4
- 3898 4
- 3909 4
- 456 3
- 1510 3
- 1630 3
- 1740 3
- 1841 3
- 1899 3
- 1919 3
- 1952 3
- 1978 3
- 1998 3
- 2121 3
- 2154 3
- 2247 3
- 2361 3
- 2427 3
- 2489 3
- 2584 3
- 2629 3
- 2679 3
- 2704 3
- 2732 3
- 2754 3
- 2792 3
- 2810 3
- 2824 3
- 2834 3
- 2850 3
- 2866 3
- 2885 3
- 2886 3
- 2890 3
- 2898 3
- 2905 3
- 2907 3
- 2920 3
- 2931 3
- 2944 3
- 2958 3
- 2993 3
- 3029 3
- 3093 3
- 3184 3
- 3244 3
- 3299 3
- 3347 3
- 3409 3
- 3429 3
- 3449 3
- 3466 3
- 3481 3
- 3489 3
- 3502 3
- 3535 3
- 3579 3
- 3648 3
- 3691 3
- 3822 3
- 3846 3
- 3871 3
- 3891 3
- 3900 3
- 3902 3
- 21 2
- 23 2
- 29 2
- 31 2
- 46 2
- 58 2
- 142 2
- 267 2
- 644 2
- 790 2
- 881 2
- 931 2
- 955 2
- 1071 2
- 1156 2
- 1250 2
- 1334 2
- 1381 2
- 1994 2
- 2048 2
- 2110 2
- 2558 2
- 2809 2
- 2870 2
- 2922 2
- 2930 2
- 3309 2
- 3478 2
- 3483 2
- 3495 2
- 3632 2
- 3790 2
- 3793 2
- 3877 2
- 3897 2
- 15 1
- 17 1
- 19 1
- 20 1
- 22 1
- 32 1
- 35 1
- 49 1
- 57 1
- 75 1
- 90 1
- 103 1
- 123 1
- 150 1
- 152 1
- 183 1
- 218 1
- 240 1
- 284 1
- 318 1
- 367 1
- 400 1
- 433 1
- 467 1
- 531 1
- 576 1
- 616 1
- 656 1
- 682 1
- 727 1
- 743 1
- 765 1
- 807 1
- 829 1
- 849 1
- 999 1
- 1019 1
- 1048 1
- 1091 1
- 1101 1
- 1121 1
- 1130 1
- 1145 1
- 1162 1
- 1171 1
- 1185 1
- 1208 1
- 1233 1
- 1272 1
- 1295 1
- 1311 1
- 1409 1
- 1431 1
- 1450 1
- 1470 1
- 1488 1
- 1540 1
- 1563 1
- 1588 1
- 1611 1
- 1661 1
- 1681 1
- 1698 1
- 1718 1
- 1766 1
- 1784 1
- 1805 1
- 1824 1
- 1853 1
- 1868 1
- 1884 1
- 1892 1
- 1924 1
- 1934 1
- 1940 1
- 1947 1
- 1955 1
- 1961 1
- 1967 1
- 1969 1
- 1981 1
- 1989 1
- 2004 1
- 2006 1
- 2015 1
- 2022 1
- 2044 1
- 2063 1
- 2072 1
- 2082 1
- 2095 1
- 2130 1
- 2137 1
- 2145 1
- 2149 1
- 2160 1
- 2164 1
- 2168 1
- 2181 1
- 2187 1
- 2192 1
- 2208 1
- 2218 1
- 2229 1
- 2237 1
- 2253 1
- 2260 1
- 2269 1
- 2283 1
- 2305 1
- 2323 1
- 2340 1
- 2376 1
- 2386 1
- 2404 1
- 2418 1
- 2440 1
- 2452 1
- 2466 1
- 2478 1
- 2501 1
- 2516 1
- 2526 1
- 2536 1
- 2575 1
- 2595 1
- 2603 1
- 2615 1
- 2623 1
- 2638 1
- 2645 1
- 2655 1
- 2666 1
- 2687 1
- 2694 1
- 2698 1
- 2703 1
- 2708 1
- 2711 1
- 2718 1
- 2727 1
- 2738 1
- 2743 1
- 2747 1
- 2751 1
- 2760 1
- 2765 1
- 2766 1
- 2769 1
- 2775 1
- 2782 1
- 2788 1
- 2794 1
- 2797 1
- 2799 1
- 2804 1
- 2806 1
- 2811 1
- 2815 1
- 2818 1
- 2823 1
- 2825 1
- 2826 1
- 2830 1
- 2832 1
- 2837 1
- 2839 1
- 2844 1
- 2848 1
- 2854 1
- 2858 1
- 2862 1
- 2865 1
- 2867 1
- 2877 1
- 2880 1
- 2883 1
- 2888 1
- 2891 1
- 2893 1
- 2894 1
- 2896 1
- 2899 1
- 2900 1
- 2903 1
- 2904 1
- 2912 1
- 2915 1
- 2919 1
- 2923 1
- 2925 1
- 2928 1
- 2933 1
- 2935 1
- 2938 1
- 2942 1
- 2946 1
- 2948 1
- 2952 1
- 2955 1
- 2963 1
- 2967 1
- 2974 1
- 2984 1
- 3003 1
- 3007 1
- 3015 1
- 3023 1
- 3040 1
- 3047 1
- 3062 1
- 3082 1
- 3101 1
- 3110 1
- 3118 1
- 3127 1
- 3150 1
- 3158 1
- 3173 1
- 3197 1
- 3210 1
- 3225 1
- 3232 1
- 3253 1
- 3263 1
- 3274 1
- 3285 1
- 3327 1
- 3339 1
- 3356 1
- 3367 1
- 3376 1
- 3383 1
- 3392 1
- 3395 1
- 3402 1
- 3413 1
- 3418 1
- 3420 1
- 3424 1
- 3434 1
- 3436 1
- 3440 1
- 3445 1
- 3455 1
- 3458 1
- 3460 1
- 3463 1
- 3471 1
- 3475 1
- 3484 1
- 3487 1
- 3491 1
- 3492 1
- 3496 1
- 3500 1
- 3503 1
- 3509 1
- 3512 1
- 3517 1
- 3519 1
- 3525 1
- 3526 1
- 3531 1
- 3532 1
- 3534 1
- 3536 1
- 3537 1
- 3541 1
- 3547 1
- 3554 1
- 3560 1
- 3573 1
- 3584 1
- 3585 1
- 3639 1
- 3659 1
- 3664 1
- 3674 1
- 3682 1
- 3703 1
- 3721 1
- 3733 1
- 3741 1
- 3764 1
- 3772 1
- 3783 1
- 3804 1
- 3809 1
- 3814 1
- 3827 1
- 3832 1
- 3838 1
- 3842 1
- 3851 1
- 3854 1
- 3861 1
- 3867 1
- 3874 1
- 3875 1
- 3887 1
- 3888 1
- 3890 1
- 3892 1
- 3893 1
- 3896 1
- 3899 1
- 3904 1
- 3906 1
- 3907 1
state 1
- Texas · 781 ✖
fips 1
- 48215 781
county 1
- Hidalgo · 781 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502314 | 2502314 | 2022-05-13 | Hidalgo | Texas | 48215 | 207289 | 3909 |
2499056 | 2499056 | 2022-05-12 | Hidalgo | Texas | 48215 | 207076 | 3909 |
2495798 | 2495798 | 2022-05-11 | Hidalgo | Texas | 48215 | 206947 | 3909 |
2492540 | 2492540 | 2022-05-10 | Hidalgo | Texas | 48215 | 206862 | 3909 |
2489282 | 2489282 | 2022-05-09 | Hidalgo | Texas | 48215 | 206779 | 3908 |
2486025 | 2486025 | 2022-05-08 | Hidalgo | Texas | 48215 | 206719 | 3908 |
2482767 | 2482767 | 2022-05-07 | Hidalgo | Texas | 48215 | 206637 | 3908 |
2479509 | 2479509 | 2022-05-06 | Hidalgo | Texas | 48215 | 206505 | 3908 |
2476251 | 2476251 | 2022-05-05 | Hidalgo | Texas | 48215 | 206416 | 3908 |
2472994 | 2472994 | 2022-05-04 | Hidalgo | Texas | 48215 | 206328 | 3907 |
2469738 | 2469738 | 2022-05-03 | Hidalgo | Texas | 48215 | 206292 | 3906 |
2466482 | 2466482 | 2022-05-02 | Hidalgo | Texas | 48215 | 206262 | 3904 |
2463227 | 2463227 | 2022-05-01 | Hidalgo | Texas | 48215 | 206205 | 3902 |
2459971 | 2459971 | 2022-04-30 | Hidalgo | Texas | 48215 | 206125 | 3902 |
2456715 | 2456715 | 2022-04-29 | Hidalgo | Texas | 48215 | 206073 | 3902 |
2453459 | 2453459 | 2022-04-28 | Hidalgo | Texas | 48215 | 206021 | 3900 |
2450203 | 2450203 | 2022-04-27 | Hidalgo | Texas | 48215 | 205980 | 3900 |
2446946 | 2446946 | 2022-04-26 | Hidalgo | Texas | 48215 | 205916 | 3900 |
2443691 | 2443691 | 2022-04-25 | Hidalgo | Texas | 48215 | 205715 | 3899 |
2440435 | 2440435 | 2022-04-24 | Hidalgo | Texas | 48215 | 205657 | 3898 |
2437179 | 2437179 | 2022-04-23 | Hidalgo | Texas | 48215 | 205597 | 3898 |
2433923 | 2433923 | 2022-04-22 | Hidalgo | Texas | 48215 | 205407 | 3898 |
2430667 | 2430667 | 2022-04-21 | Hidalgo | Texas | 48215 | 205179 | 3898 |
2427411 | 2427411 | 2022-04-20 | Hidalgo | Texas | 48215 | 205003 | 3897 |
2424155 | 2424155 | 2022-04-19 | Hidalgo | Texas | 48215 | 204849 | 3897 |
2420899 | 2420899 | 2022-04-18 | Hidalgo | Texas | 48215 | 204695 | 3896 |
2417643 | 2417643 | 2022-04-17 | Hidalgo | Texas | 48215 | 204245 | 3895 |
2414387 | 2414387 | 2022-04-16 | Hidalgo | Texas | 48215 | 204245 | 3895 |
2411131 | 2411131 | 2022-04-15 | Hidalgo | Texas | 48215 | 204245 | 3895 |
2407875 | 2407875 | 2022-04-14 | Hidalgo | Texas | 48215 | 204245 | 3895 |
2404619 | 2404619 | 2022-04-13 | Hidalgo | Texas | 48215 | 204110 | 3895 |
2401364 | 2401364 | 2022-04-12 | Hidalgo | Texas | 48215 | 203945 | 3893 |
2398109 | 2398109 | 2022-04-11 | Hidalgo | Texas | 48215 | 203755 | 3892 |
2394854 | 2394854 | 2022-04-10 | Hidalgo | Texas | 48215 | 203741 | 3891 |
2391598 | 2391598 | 2022-04-09 | Hidalgo | Texas | 48215 | 203709 | 3891 |
2388342 | 2388342 | 2022-04-08 | Hidalgo | Texas | 48215 | 203541 | 3891 |
2385087 | 2385087 | 2022-04-07 | Hidalgo | Texas | 48215 | 203356 | 3890 |
2381832 | 2381832 | 2022-04-06 | Hidalgo | Texas | 48215 | 201895 | 3888 |
2378577 | 2378577 | 2022-04-05 | Hidalgo | Texas | 48215 | 201727 | 3887 |
2375323 | 2375323 | 2022-04-04 | Hidalgo | Texas | 48215 | 201564 | 3879 |
2372071 | 2372071 | 2022-04-03 | Hidalgo | Texas | 48215 | 201554 | 3879 |
2368818 | 2368818 | 2022-04-02 | Hidalgo | Texas | 48215 | 201533 | 3879 |
2365565 | 2365565 | 2022-04-01 | Hidalgo | Texas | 48215 | 201366 | 3879 |
2362312 | 2362312 | 2022-03-31 | Hidalgo | Texas | 48215 | 201195 | 3879 |
2359058 | 2359058 | 2022-03-30 | Hidalgo | Texas | 48215 | 201001 | 3879 |
2355804 | 2355804 | 2022-03-29 | Hidalgo | Texas | 48215 | 200833 | 3879 |
2352551 | 2352551 | 2022-03-28 | Hidalgo | Texas | 48215 | 200371 | 3879 |
2349299 | 2349299 | 2022-03-27 | Hidalgo | Texas | 48215 | 200347 | 3879 |
2346046 | 2346046 | 2022-03-26 | Hidalgo | Texas | 48215 | 200335 | 3879 |
2342793 | 2342793 | 2022-03-25 | Hidalgo | Texas | 48215 | 200119 | 3879 |
2339540 | 2339540 | 2022-03-24 | Hidalgo | Texas | 48215 | 199850 | 3877 |
2336286 | 2336286 | 2022-03-23 | Hidalgo | Texas | 48215 | 199670 | 3877 |
2333032 | 2333032 | 2022-03-22 | Hidalgo | Texas | 48215 | 199451 | 3875 |
2329779 | 2329779 | 2022-03-21 | Hidalgo | Texas | 48215 | 199310 | 3874 |
2326527 | 2326527 | 2022-03-20 | Hidalgo | Texas | 48215 | 199294 | 3871 |
2323274 | 2323274 | 2022-03-19 | Hidalgo | Texas | 48215 | 199180 | 3871 |
2320020 | 2320020 | 2022-03-18 | Hidalgo | Texas | 48215 | 198976 | 3871 |
2316766 | 2316766 | 2022-03-17 | Hidalgo | Texas | 48215 | 198726 | 3867 |
2313513 | 2313513 | 2022-03-16 | Hidalgo | Texas | 48215 | 198439 | 3861 |
2310260 | 2310260 | 2022-03-15 | Hidalgo | Texas | 48215 | 198112 | 3854 |
2307007 | 2307007 | 2022-03-14 | Hidalgo | Texas | 48215 | 197807 | 3851 |
2303756 | 2303756 | 2022-03-13 | Hidalgo | Texas | 48215 | 197729 | 3846 |
2300504 | 2300504 | 2022-03-12 | Hidalgo | Texas | 48215 | 197608 | 3846 |
2297252 | 2297252 | 2022-03-11 | Hidalgo | Texas | 48215 | 197241 | 3846 |
2294000 | 2294000 | 2022-03-10 | Hidalgo | Texas | 48215 | 196678 | 3842 |
2290748 | 2290748 | 2022-03-09 | Hidalgo | Texas | 48215 | 196096 | 3838 |
2287496 | 2287496 | 2022-03-08 | Hidalgo | Texas | 48215 | 195698 | 3832 |
2284244 | 2284244 | 2022-03-07 | Hidalgo | Texas | 48215 | 195191 | 3827 |
2280992 | 2280992 | 2022-03-06 | Hidalgo | Texas | 48215 | 194956 | 3822 |
2277739 | 2277739 | 2022-03-05 | Hidalgo | Texas | 48215 | 194923 | 3822 |
2274486 | 2274486 | 2022-03-04 | Hidalgo | Texas | 48215 | 194436 | 3822 |
2271233 | 2271233 | 2022-03-03 | Hidalgo | Texas | 48215 | 194128 | 3814 |
2267981 | 2267981 | 2022-03-02 | Hidalgo | Texas | 48215 | 193656 | 3809 |
2264728 | 2264728 | 2022-03-01 | Hidalgo | Texas | 48215 | 193318 | 3804 |
2261478 | 2261478 | 2022-02-28 | Hidalgo | Texas | 48215 | 192771 | 3793 |
2258227 | 2258227 | 2022-02-27 | Hidalgo | Texas | 48215 | 192643 | 3793 |
2254976 | 2254976 | 2022-02-26 | Hidalgo | Texas | 48215 | 192610 | 3790 |
2251725 | 2251725 | 2022-02-25 | Hidalgo | Texas | 48215 | 192215 | 3790 |
2248474 | 2248474 | 2022-02-24 | Hidalgo | Texas | 48215 | 191747 | 3783 |
2245223 | 2245223 | 2022-02-23 | Hidalgo | Texas | 48215 | 191128 | 3772 |
2241972 | 2241972 | 2022-02-22 | Hidalgo | Texas | 48215 | 190685 | 3764 |
2238721 | 2238721 | 2022-02-21 | Hidalgo | Texas | 48215 | 190399 | 3750 |
2235470 | 2235470 | 2022-02-20 | Hidalgo | Texas | 48215 | 189794 | 3750 |
2232219 | 2232219 | 2022-02-19 | Hidalgo | Texas | 48215 | 189665 | 3750 |
2228968 | 2228968 | 2022-02-18 | Hidalgo | Texas | 48215 | 188911 | 3750 |
2225717 | 2225717 | 2022-02-17 | Hidalgo | Texas | 48215 | 188507 | 3741 |
2222466 | 2222466 | 2022-02-16 | Hidalgo | Texas | 48215 | 187775 | 3733 |
2219215 | 2219215 | 2022-02-15 | Hidalgo | Texas | 48215 | 187453 | 3721 |
2215964 | 2215964 | 2022-02-14 | Hidalgo | Texas | 48215 | 186418 | 3703 |
2212713 | 2212713 | 2022-02-13 | Hidalgo | Texas | 48215 | 185582 | 3691 |
2209460 | 2209460 | 2022-02-12 | Hidalgo | Texas | 48215 | 184443 | 3691 |
2206207 | 2206207 | 2022-02-11 | Hidalgo | Texas | 48215 | 183902 | 3691 |
2202954 | 2202954 | 2022-02-10 | Hidalgo | Texas | 48215 | 183396 | 3682 |
2199700 | 2199700 | 2022-02-09 | Hidalgo | Texas | 48215 | 182332 | 3674 |
2196446 | 2196446 | 2022-02-08 | Hidalgo | Texas | 48215 | 181828 | 3664 |
2193192 | 2193192 | 2022-02-07 | Hidalgo | Texas | 48215 | 181376 | 3659 |
2189938 | 2189938 | 2022-02-06 | Hidalgo | Texas | 48215 | 179721 | 3648 |
2186685 | 2186685 | 2022-02-05 | Hidalgo | Texas | 48215 | 178997 | 3648 |
2183433 | 2183433 | 2022-02-04 | Hidalgo | Texas | 48215 | 178607 | 3648 |
2180181 | 2180181 | 2022-02-03 | Hidalgo | Texas | 48215 | 177999 | 3639 |
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);