ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,507 rows where county = "Hidalgo" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
deaths 450 ✖
- 9 225
- 0 110
- 11 81
- 12 80
- 2 72
- 14 49
- 10 40
- 13 34
- 3 26
- 6 19
- 1 18
- 4 18
- 8 16
- 15 12
- 3879 11
- 3504 7
- 7 6
- 3522 6
- 3600 6
- 2878 5
- 2911 5
- 3493 5
- 3528 5
- 3895 5
- 3908 5
- 5 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
- 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 2
- Texas 781
- New Mexico 726
county 1
- Hidalgo · 1,507 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
155918 | 155918 | 2020-05-18 | Hidalgo | New Mexico | 35023 | 1 | 0 |
158936 | 158936 | 2020-05-19 | Hidalgo | New Mexico | 35023 | 1 | 0 |
161962 | 161962 | 2020-05-20 | Hidalgo | New Mexico | 35023 | 1 | 0 |
164991 | 164991 | 2020-05-21 | Hidalgo | New Mexico | 35023 | 1 | 0 |
168027 | 168027 | 2020-05-22 | Hidalgo | New Mexico | 35023 | 1 | 0 |
171066 | 171066 | 2020-05-23 | Hidalgo | New Mexico | 35023 | 1 | 0 |
174108 | 174108 | 2020-05-24 | Hidalgo | New Mexico | 35023 | 1 | 0 |
177151 | 177151 | 2020-05-25 | Hidalgo | New Mexico | 35023 | 1 | 0 |
180195 | 180195 | 2020-05-26 | Hidalgo | New Mexico | 35023 | 1 | 0 |
183243 | 183243 | 2020-05-27 | Hidalgo | New Mexico | 35023 | 1 | 0 |
186300 | 186300 | 2020-05-28 | Hidalgo | New Mexico | 35023 | 1 | 0 |
189360 | 189360 | 2020-05-29 | Hidalgo | New Mexico | 35023 | 1 | 0 |
192424 | 192424 | 2020-05-30 | Hidalgo | New Mexico | 35023 | 1 | 0 |
195494 | 195494 | 2020-05-31 | Hidalgo | New Mexico | 35023 | 1 | 0 |
198567 | 198567 | 2020-06-01 | Hidalgo | New Mexico | 35023 | 1 | 0 |
201641 | 201641 | 2020-06-02 | Hidalgo | New Mexico | 35023 | 1 | 0 |
204718 | 204718 | 2020-06-03 | Hidalgo | New Mexico | 35023 | 1 | 0 |
207799 | 207799 | 2020-06-04 | Hidalgo | New Mexico | 35023 | 1 | 0 |
210881 | 210881 | 2020-06-05 | Hidalgo | New Mexico | 35023 | 1 | 0 |
213965 | 213965 | 2020-06-06 | Hidalgo | New Mexico | 35023 | 1 | 0 |
217054 | 217054 | 2020-06-07 | Hidalgo | New Mexico | 35023 | 1 | 0 |
220146 | 220146 | 2020-06-08 | Hidalgo | New Mexico | 35023 | 1 | 0 |
223241 | 223241 | 2020-06-09 | Hidalgo | New Mexico | 35023 | 1 | 0 |
226341 | 226341 | 2020-06-10 | Hidalgo | New Mexico | 35023 | 1 | 0 |
229445 | 229445 | 2020-06-11 | Hidalgo | New Mexico | 35023 | 1 | 0 |
232550 | 232550 | 2020-06-12 | Hidalgo | New Mexico | 35023 | 2 | 0 |
235655 | 235655 | 2020-06-13 | Hidalgo | New Mexico | 35023 | 3 | 0 |
238762 | 238762 | 2020-06-14 | Hidalgo | New Mexico | 35023 | 3 | 0 |
241872 | 241872 | 2020-06-15 | Hidalgo | New Mexico | 35023 | 20 | 0 |
244984 | 244984 | 2020-06-16 | Hidalgo | New Mexico | 35023 | 23 | 0 |
248097 | 248097 | 2020-06-17 | Hidalgo | New Mexico | 35023 | 23 | 0 |
251212 | 251212 | 2020-06-18 | Hidalgo | New Mexico | 35023 | 23 | 0 |
254327 | 254327 | 2020-06-19 | Hidalgo | New Mexico | 35023 | 26 | 0 |
257450 | 257450 | 2020-06-20 | Hidalgo | New Mexico | 35023 | 26 | 0 |
260576 | 260576 | 2020-06-21 | Hidalgo | New Mexico | 35023 | 28 | 0 |
263705 | 263705 | 2020-06-22 | Hidalgo | New Mexico | 35023 | 39 | 0 |
266832 | 266832 | 2020-06-23 | Hidalgo | New Mexico | 35023 | 39 | 0 |
269967 | 269967 | 2020-06-24 | Hidalgo | New Mexico | 35023 | 39 | 0 |
273106 | 273106 | 2020-06-25 | Hidalgo | New Mexico | 35023 | 40 | 0 |
276251 | 276251 | 2020-06-26 | Hidalgo | New Mexico | 35023 | 39 | 0 |
279399 | 279399 | 2020-06-27 | Hidalgo | New Mexico | 35023 | 46 | 0 |
282546 | 282546 | 2020-06-28 | Hidalgo | New Mexico | 35023 | 46 | 0 |
285691 | 285691 | 2020-06-29 | Hidalgo | New Mexico | 35023 | 49 | 0 |
288841 | 288841 | 2020-06-30 | Hidalgo | New Mexico | 35023 | 49 | 0 |
291993 | 291993 | 2020-07-01 | Hidalgo | New Mexico | 35023 | 49 | 0 |
295148 | 295148 | 2020-07-02 | Hidalgo | New Mexico | 35023 | 54 | 0 |
298308 | 298308 | 2020-07-03 | Hidalgo | New Mexico | 35023 | 54 | 0 |
301471 | 301471 | 2020-07-04 | Hidalgo | New Mexico | 35023 | 58 | 0 |
304634 | 304634 | 2020-07-05 | Hidalgo | New Mexico | 35023 | 59 | 0 |
307801 | 307801 | 2020-07-06 | Hidalgo | New Mexico | 35023 | 60 | 0 |
310969 | 310969 | 2020-07-07 | Hidalgo | New Mexico | 35023 | 61 | 0 |
314140 | 314140 | 2020-07-08 | Hidalgo | New Mexico | 35023 | 62 | 0 |
317314 | 317314 | 2020-07-09 | Hidalgo | New Mexico | 35023 | 64 | 0 |
320490 | 320490 | 2020-07-10 | Hidalgo | New Mexico | 35023 | 72 | 0 |
323670 | 323670 | 2020-07-11 | Hidalgo | New Mexico | 35023 | 72 | 0 |
326854 | 326854 | 2020-07-12 | Hidalgo | New Mexico | 35023 | 72 | 0 |
330041 | 330041 | 2020-07-13 | Hidalgo | New Mexico | 35023 | 74 | 0 |
333231 | 333231 | 2020-07-14 | Hidalgo | New Mexico | 35023 | 75 | 0 |
336425 | 336425 | 2020-07-15 | Hidalgo | New Mexico | 35023 | 75 | 0 |
339621 | 339621 | 2020-07-16 | Hidalgo | New Mexico | 35023 | 76 | 0 |
342819 | 342819 | 2020-07-17 | Hidalgo | New Mexico | 35023 | 77 | 0 |
346018 | 346018 | 2020-07-18 | Hidalgo | New Mexico | 35023 | 78 | 0 |
349219 | 349219 | 2020-07-19 | Hidalgo | New Mexico | 35023 | 78 | 0 |
352422 | 352422 | 2020-07-20 | Hidalgo | New Mexico | 35023 | 78 | 0 |
355625 | 355625 | 2020-07-21 | Hidalgo | New Mexico | 35023 | 80 | 0 |
358829 | 358829 | 2020-07-22 | Hidalgo | New Mexico | 35023 | 81 | 0 |
362035 | 362035 | 2020-07-23 | Hidalgo | New Mexico | 35023 | 84 | 0 |
365241 | 365241 | 2020-07-24 | Hidalgo | New Mexico | 35023 | 85 | 0 |
368450 | 368450 | 2020-07-25 | Hidalgo | New Mexico | 35023 | 85 | 0 |
371662 | 371662 | 2020-07-26 | Hidalgo | New Mexico | 35023 | 85 | 0 |
374874 | 374874 | 2020-07-27 | Hidalgo | New Mexico | 35023 | 85 | 0 |
378089 | 378089 | 2020-07-28 | Hidalgo | New Mexico | 35023 | 85 | 0 |
381307 | 381307 | 2020-07-29 | Hidalgo | New Mexico | 35023 | 85 | 0 |
384525 | 384525 | 2020-07-30 | Hidalgo | New Mexico | 35023 | 85 | 0 |
387742 | 387742 | 2020-07-31 | Hidalgo | New Mexico | 35023 | 85 | 0 |
390958 | 390958 | 2020-08-01 | Hidalgo | New Mexico | 35023 | 88 | 0 |
394175 | 394175 | 2020-08-02 | Hidalgo | New Mexico | 35023 | 88 | 0 |
397392 | 397392 | 2020-08-03 | Hidalgo | New Mexico | 35023 | 88 | 0 |
400607 | 400607 | 2020-08-04 | Hidalgo | New Mexico | 35023 | 88 | 0 |
403825 | 403825 | 2020-08-05 | Hidalgo | New Mexico | 35023 | 88 | 0 |
407044 | 407044 | 2020-08-06 | Hidalgo | New Mexico | 35023 | 89 | 0 |
410264 | 410264 | 2020-08-07 | Hidalgo | New Mexico | 35023 | 89 | 0 |
413484 | 413484 | 2020-08-08 | Hidalgo | New Mexico | 35023 | 90 | 0 |
416705 | 416705 | 2020-08-09 | Hidalgo | New Mexico | 35023 | 90 | 0 |
419925 | 419925 | 2020-08-10 | Hidalgo | New Mexico | 35023 | 90 | 0 |
423148 | 423148 | 2020-08-11 | Hidalgo | New Mexico | 35023 | 90 | 0 |
426371 | 426371 | 2020-08-12 | Hidalgo | New Mexico | 35023 | 90 | 0 |
429595 | 429595 | 2020-08-13 | Hidalgo | New Mexico | 35023 | 90 | 0 |
432822 | 432822 | 2020-08-14 | Hidalgo | New Mexico | 35023 | 90 | 0 |
436048 | 436048 | 2020-08-15 | Hidalgo | New Mexico | 35023 | 90 | 0 |
439273 | 439273 | 2020-08-16 | Hidalgo | New Mexico | 35023 | 90 | 0 |
442500 | 442500 | 2020-08-17 | Hidalgo | New Mexico | 35023 | 93 | 0 |
445726 | 445726 | 2020-08-18 | Hidalgo | New Mexico | 35023 | 93 | 0 |
448953 | 448953 | 2020-08-19 | Hidalgo | New Mexico | 35023 | 93 | 0 |
452182 | 452182 | 2020-08-20 | Hidalgo | New Mexico | 35023 | 93 | 0 |
455410 | 455410 | 2020-08-21 | Hidalgo | New Mexico | 35023 | 93 | 0 |
458637 | 458637 | 2020-08-22 | Hidalgo | New Mexico | 35023 | 93 | 1 |
461865 | 461865 | 2020-08-23 | Hidalgo | New Mexico | 35023 | 93 | 1 |
465095 | 465095 | 2020-08-24 | Hidalgo | New Mexico | 35023 | 93 | 1 |
468323 | 468323 | 2020-08-25 | Hidalgo | New Mexico | 35023 | 93 | 1 |
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);