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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501406 | 2501406 | 2022-05-13 | Hidalgo | New Mexico | 35023 | 1104 | 15 |
2502314 | 2502314 | 2022-05-13 | Hidalgo | Texas | 48215 | 207289 | 3909 |
2498148 | 2498148 | 2022-05-12 | Hidalgo | New Mexico | 35023 | 1104 | 15 |
2499056 | 2499056 | 2022-05-12 | Hidalgo | Texas | 48215 | 207076 | 3909 |
2494890 | 2494890 | 2022-05-11 | Hidalgo | New Mexico | 35023 | 1103 | 15 |
2495798 | 2495798 | 2022-05-11 | Hidalgo | Texas | 48215 | 206947 | 3909 |
2491632 | 2491632 | 2022-05-10 | Hidalgo | New Mexico | 35023 | 1103 | 15 |
2492540 | 2492540 | 2022-05-10 | Hidalgo | Texas | 48215 | 206862 | 3909 |
2488374 | 2488374 | 2022-05-09 | Hidalgo | New Mexico | 35023 | 1103 | 15 |
2489282 | 2489282 | 2022-05-09 | Hidalgo | Texas | 48215 | 206779 | 3908 |
2485117 | 2485117 | 2022-05-08 | Hidalgo | New Mexico | 35023 | 1103 | 15 |
2486025 | 2486025 | 2022-05-08 | Hidalgo | Texas | 48215 | 206719 | 3908 |
2481859 | 2481859 | 2022-05-07 | Hidalgo | New Mexico | 35023 | 1103 | 15 |
2482767 | 2482767 | 2022-05-07 | Hidalgo | Texas | 48215 | 206637 | 3908 |
2478601 | 2478601 | 2022-05-06 | Hidalgo | New Mexico | 35023 | 1103 | 15 |
2479509 | 2479509 | 2022-05-06 | Hidalgo | Texas | 48215 | 206505 | 3908 |
2475343 | 2475343 | 2022-05-05 | Hidalgo | New Mexico | 35023 | 1102 | 15 |
2476251 | 2476251 | 2022-05-05 | Hidalgo | Texas | 48215 | 206416 | 3908 |
2472086 | 2472086 | 2022-05-04 | Hidalgo | New Mexico | 35023 | 1102 | 15 |
2472994 | 2472994 | 2022-05-04 | Hidalgo | Texas | 48215 | 206328 | 3907 |
2468830 | 2468830 | 2022-05-03 | Hidalgo | New Mexico | 35023 | 1102 | 15 |
2469738 | 2469738 | 2022-05-03 | Hidalgo | Texas | 48215 | 206292 | 3906 |
2465574 | 2465574 | 2022-05-02 | Hidalgo | New Mexico | 35023 | 1102 | 14 |
2466482 | 2466482 | 2022-05-02 | Hidalgo | Texas | 48215 | 206262 | 3904 |
2462319 | 2462319 | 2022-05-01 | Hidalgo | New Mexico | 35023 | 1102 | 14 |
2463227 | 2463227 | 2022-05-01 | Hidalgo | Texas | 48215 | 206205 | 3902 |
2459063 | 2459063 | 2022-04-30 | Hidalgo | New Mexico | 35023 | 1102 | 14 |
2459971 | 2459971 | 2022-04-30 | Hidalgo | Texas | 48215 | 206125 | 3902 |
2455807 | 2455807 | 2022-04-29 | Hidalgo | New Mexico | 35023 | 1102 | 14 |
2456715 | 2456715 | 2022-04-29 | Hidalgo | Texas | 48215 | 206073 | 3902 |
2452551 | 2452551 | 2022-04-28 | Hidalgo | New Mexico | 35023 | 1102 | 14 |
2453459 | 2453459 | 2022-04-28 | Hidalgo | Texas | 48215 | 206021 | 3900 |
2449295 | 2449295 | 2022-04-27 | Hidalgo | New Mexico | 35023 | 1101 | 14 |
2450203 | 2450203 | 2022-04-27 | Hidalgo | Texas | 48215 | 205980 | 3900 |
2446038 | 2446038 | 2022-04-26 | Hidalgo | New Mexico | 35023 | 1101 | 14 |
2446946 | 2446946 | 2022-04-26 | Hidalgo | Texas | 48215 | 205916 | 3900 |
2442783 | 2442783 | 2022-04-25 | Hidalgo | New Mexico | 35023 | 1101 | 14 |
2443691 | 2443691 | 2022-04-25 | Hidalgo | Texas | 48215 | 205715 | 3899 |
2439527 | 2439527 | 2022-04-24 | Hidalgo | New Mexico | 35023 | 1100 | 14 |
2440435 | 2440435 | 2022-04-24 | Hidalgo | Texas | 48215 | 205657 | 3898 |
2436271 | 2436271 | 2022-04-23 | Hidalgo | New Mexico | 35023 | 1100 | 14 |
2437179 | 2437179 | 2022-04-23 | Hidalgo | Texas | 48215 | 205597 | 3898 |
2433015 | 2433015 | 2022-04-22 | Hidalgo | New Mexico | 35023 | 1100 | 14 |
2433923 | 2433923 | 2022-04-22 | Hidalgo | Texas | 48215 | 205407 | 3898 |
2429759 | 2429759 | 2022-04-21 | Hidalgo | New Mexico | 35023 | 1100 | 14 |
2430667 | 2430667 | 2022-04-21 | Hidalgo | Texas | 48215 | 205179 | 3898 |
2426503 | 2426503 | 2022-04-20 | Hidalgo | New Mexico | 35023 | 1100 | 14 |
2427411 | 2427411 | 2022-04-20 | Hidalgo | Texas | 48215 | 205003 | 3897 |
2423247 | 2423247 | 2022-04-19 | Hidalgo | New Mexico | 35023 | 1100 | 14 |
2424155 | 2424155 | 2022-04-19 | Hidalgo | Texas | 48215 | 204849 | 3897 |
2419990 | 2419990 | 2022-04-18 | Hidalgo | New Mexico | 35023 | 1099 | 14 |
2420899 | 2420899 | 2022-04-18 | Hidalgo | Texas | 48215 | 204695 | 3896 |
2416735 | 2416735 | 2022-04-17 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2417643 | 2417643 | 2022-04-17 | Hidalgo | Texas | 48215 | 204245 | 3895 |
2413479 | 2413479 | 2022-04-16 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2414387 | 2414387 | 2022-04-16 | Hidalgo | Texas | 48215 | 204245 | 3895 |
2410223 | 2410223 | 2022-04-15 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2411131 | 2411131 | 2022-04-15 | Hidalgo | Texas | 48215 | 204245 | 3895 |
2406967 | 2406967 | 2022-04-14 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2407875 | 2407875 | 2022-04-14 | Hidalgo | Texas | 48215 | 204245 | 3895 |
2403711 | 2403711 | 2022-04-13 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2404619 | 2404619 | 2022-04-13 | Hidalgo | Texas | 48215 | 204110 | 3895 |
2400456 | 2400456 | 2022-04-12 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2401364 | 2401364 | 2022-04-12 | Hidalgo | Texas | 48215 | 203945 | 3893 |
2397201 | 2397201 | 2022-04-11 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2398109 | 2398109 | 2022-04-11 | Hidalgo | Texas | 48215 | 203755 | 3892 |
2393946 | 2393946 | 2022-04-10 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2394854 | 2394854 | 2022-04-10 | Hidalgo | Texas | 48215 | 203741 | 3891 |
2390690 | 2390690 | 2022-04-09 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2391598 | 2391598 | 2022-04-09 | Hidalgo | Texas | 48215 | 203709 | 3891 |
2387434 | 2387434 | 2022-04-08 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2388342 | 2388342 | 2022-04-08 | Hidalgo | Texas | 48215 | 203541 | 3891 |
2384179 | 2384179 | 2022-04-07 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2385087 | 2385087 | 2022-04-07 | Hidalgo | Texas | 48215 | 203356 | 3890 |
2380924 | 2380924 | 2022-04-06 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2381832 | 2381832 | 2022-04-06 | Hidalgo | Texas | 48215 | 201895 | 3888 |
2377669 | 2377669 | 2022-04-05 | Hidalgo | New Mexico | 35023 | 1094 | 14 |
2378577 | 2378577 | 2022-04-05 | Hidalgo | Texas | 48215 | 201727 | 3887 |
2374416 | 2374416 | 2022-04-04 | Hidalgo | New Mexico | 35023 | 1094 | 14 |
2375323 | 2375323 | 2022-04-04 | Hidalgo | Texas | 48215 | 201564 | 3879 |
2371164 | 2371164 | 2022-04-03 | Hidalgo | New Mexico | 35023 | 1087 | 14 |
2372071 | 2372071 | 2022-04-03 | Hidalgo | Texas | 48215 | 201554 | 3879 |
2367911 | 2367911 | 2022-04-02 | Hidalgo | New Mexico | 35023 | 1087 | 14 |
2368818 | 2368818 | 2022-04-02 | Hidalgo | Texas | 48215 | 201533 | 3879 |
2364658 | 2364658 | 2022-04-01 | Hidalgo | New Mexico | 35023 | 1087 | 14 |
2365565 | 2365565 | 2022-04-01 | Hidalgo | Texas | 48215 | 201366 | 3879 |
2361404 | 2361404 | 2022-03-31 | Hidalgo | New Mexico | 35023 | 1087 | 14 |
2362312 | 2362312 | 2022-03-31 | Hidalgo | Texas | 48215 | 201195 | 3879 |
2358150 | 2358150 | 2022-03-30 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2359058 | 2359058 | 2022-03-30 | Hidalgo | Texas | 48215 | 201001 | 3879 |
2354897 | 2354897 | 2022-03-29 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2355804 | 2355804 | 2022-03-29 | Hidalgo | Texas | 48215 | 200833 | 3879 |
2351644 | 2351644 | 2022-03-28 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2352551 | 2352551 | 2022-03-28 | Hidalgo | Texas | 48215 | 200371 | 3879 |
2348392 | 2348392 | 2022-03-27 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2349299 | 2349299 | 2022-03-27 | Hidalgo | Texas | 48215 | 200347 | 3879 |
2345139 | 2345139 | 2022-03-26 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2346046 | 2346046 | 2022-03-26 | Hidalgo | Texas | 48215 | 200335 | 3879 |
2341886 | 2341886 | 2022-03-25 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2342793 | 2342793 | 2022-03-25 | Hidalgo | Texas | 48215 | 200119 | 3879 |
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);