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 county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date | county ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10659 | 10659 | 2020-03-24 | Hidalgo | Texas | 48215 | 2 | 0 |
12152 | 12152 | 2020-03-25 | Hidalgo | Texas | 48215 | 2 | 0 |
13781 | 13781 | 2020-03-26 | Hidalgo | Texas | 48215 | 7 | 0 |
15536 | 15536 | 2020-03-27 | Hidalgo | Texas | 48215 | 18 | 0 |
17405 | 17405 | 2020-03-28 | Hidalgo | Texas | 48215 | 18 | 0 |
19359 | 19359 | 2020-03-29 | Hidalgo | Texas | 48215 | 27 | 0 |
21418 | 21418 | 2020-03-30 | Hidalgo | Texas | 48215 | 28 | 0 |
23557 | 23557 | 2020-03-31 | Hidalgo | Texas | 48215 | 38 | 0 |
25767 | 25767 | 2020-04-01 | Hidalgo | Texas | 48215 | 46 | 0 |
28050 | 28050 | 2020-04-02 | Hidalgo | Texas | 48215 | 62 | 0 |
30385 | 30385 | 2020-04-03 | Hidalgo | Texas | 48215 | 79 | 0 |
32779 | 32779 | 2020-04-04 | Hidalgo | Texas | 48215 | 86 | 0 |
35217 | 35217 | 2020-04-05 | Hidalgo | Texas | 48215 | 86 | 0 |
37693 | 37693 | 2020-04-06 | Hidalgo | Texas | 48215 | 99 | 0 |
40220 | 40220 | 2020-04-07 | Hidalgo | Texas | 48215 | 128 | 1 |
42787 | 42787 | 2020-04-08 | Hidalgo | Texas | 48215 | 128 | 1 |
45376 | 45376 | 2020-04-09 | Hidalgo | Texas | 48215 | 139 | 1 |
47996 | 47996 | 2020-04-10 | Hidalgo | Texas | 48215 | 146 | 1 |
50654 | 50654 | 2020-04-11 | Hidalgo | Texas | 48215 | 188 | 1 |
53329 | 53329 | 2020-04-12 | Hidalgo | Texas | 48215 | 188 | 1 |
56017 | 56017 | 2020-04-13 | Hidalgo | Texas | 48215 | 190 | 1 |
58722 | 58722 | 2020-04-14 | Hidalgo | Texas | 48215 | 198 | 1 |
61440 | 61440 | 2020-04-15 | Hidalgo | Texas | 48215 | 217 | 1 |
64167 | 64167 | 2020-04-16 | Hidalgo | Texas | 48215 | 225 | 3 |
66914 | 66914 | 2020-04-17 | Hidalgo | Texas | 48215 | 242 | 3 |
69674 | 69674 | 2020-04-18 | Hidalgo | Texas | 48215 | 255 | 3 |
72442 | 72442 | 2020-04-19 | Hidalgo | Texas | 48215 | 255 | 3 |
75218 | 75218 | 2020-04-20 | Hidalgo | Texas | 48215 | 261 | 3 |
78000 | 78000 | 2020-04-21 | Hidalgo | Texas | 48215 | 275 | 3 |
80791 | 80791 | 2020-04-22 | Hidalgo | Texas | 48215 | 275 | 3 |
83591 | 83591 | 2020-04-23 | Hidalgo | Texas | 48215 | 290 | 4 |
86396 | 86396 | 2020-04-24 | Hidalgo | Texas | 48215 | 299 | 4 |
89211 | 89211 | 2020-04-25 | Hidalgo | Texas | 48215 | 303 | 4 |
92028 | 92028 | 2020-04-26 | Hidalgo | Texas | 48215 | 308 | 4 |
94857 | 94857 | 2020-04-27 | Hidalgo | Texas | 48215 | 308 | 4 |
97697 | 97697 | 2020-04-28 | Hidalgo | Texas | 48215 | 315 | 6 |
100547 | 100547 | 2020-04-29 | Hidalgo | Texas | 48215 | 324 | 6 |
103402 | 103402 | 2020-04-30 | Hidalgo | Texas | 48215 | 334 | 6 |
106266 | 106266 | 2020-05-01 | Hidalgo | Texas | 48215 | 339 | 6 |
109135 | 109135 | 2020-05-02 | Hidalgo | Texas | 48215 | 340 | 6 |
112009 | 112009 | 2020-05-03 | Hidalgo | Texas | 48215 | 341 | 6 |
114891 | 114891 | 2020-05-04 | Hidalgo | Texas | 48215 | 341 | 6 |
117850 | 117850 | 2020-05-05 | Hidalgo | Texas | 48215 | 353 | 7 |
120814 | 120814 | 2020-05-06 | Hidalgo | Texas | 48215 | 353 | 7 |
123793 | 123793 | 2020-05-07 | Hidalgo | Texas | 48215 | 368 | 7 |
126776 | 126776 | 2020-05-08 | Hidalgo | Texas | 48215 | 377 | 7 |
129765 | 129765 | 2020-05-09 | Hidalgo | Texas | 48215 | 387 | 8 |
132755 | 132755 | 2020-05-10 | Hidalgo | Texas | 48215 | 389 | 8 |
135746 | 135746 | 2020-05-11 | Hidalgo | Texas | 48215 | 394 | 8 |
138736 | 138736 | 2020-05-12 | Hidalgo | Texas | 48215 | 403 | 8 |
141732 | 141732 | 2020-05-13 | Hidalgo | Texas | 48215 | 409 | 10 |
144729 | 144729 | 2020-05-14 | Hidalgo | Texas | 48215 | 417 | 10 |
147733 | 147733 | 2020-05-15 | Hidalgo | Texas | 48215 | 425 | 10 |
150741 | 150741 | 2020-05-16 | Hidalgo | Texas | 48215 | 425 | 10 |
153752 | 153752 | 2020-05-17 | Hidalgo | Texas | 48215 | 440 | 10 |
155918 | 155918 | 2020-05-18 | Hidalgo | New Mexico | 35023 | 1 | 0 |
156769 | 156769 | 2020-05-18 | Hidalgo | Texas | 48215 | 448 | 10 |
158936 | 158936 | 2020-05-19 | Hidalgo | New Mexico | 35023 | 1 | 0 |
159791 | 159791 | 2020-05-19 | Hidalgo | Texas | 48215 | 457 | 10 |
161962 | 161962 | 2020-05-20 | Hidalgo | New Mexico | 35023 | 1 | 0 |
162819 | 162819 | 2020-05-20 | Hidalgo | Texas | 48215 | 467 | 10 |
164991 | 164991 | 2020-05-21 | Hidalgo | New Mexico | 35023 | 1 | 0 |
165848 | 165848 | 2020-05-21 | Hidalgo | Texas | 48215 | 472 | 10 |
168027 | 168027 | 2020-05-22 | Hidalgo | New Mexico | 35023 | 1 | 0 |
168884 | 168884 | 2020-05-22 | Hidalgo | Texas | 48215 | 482 | 10 |
171066 | 171066 | 2020-05-23 | Hidalgo | New Mexico | 35023 | 1 | 0 |
171924 | 171924 | 2020-05-23 | Hidalgo | Texas | 48215 | 482 | 10 |
174108 | 174108 | 2020-05-24 | Hidalgo | New Mexico | 35023 | 1 | 0 |
174967 | 174967 | 2020-05-24 | Hidalgo | Texas | 48215 | 497 | 10 |
177151 | 177151 | 2020-05-25 | Hidalgo | New Mexico | 35023 | 1 | 0 |
178011 | 178011 | 2020-05-25 | Hidalgo | Texas | 48215 | 504 | 10 |
180195 | 180195 | 2020-05-26 | Hidalgo | New Mexico | 35023 | 1 | 0 |
181054 | 181054 | 2020-05-26 | Hidalgo | Texas | 48215 | 516 | 10 |
183243 | 183243 | 2020-05-27 | Hidalgo | New Mexico | 35023 | 1 | 0 |
184104 | 184104 | 2020-05-27 | Hidalgo | Texas | 48215 | 537 | 10 |
186300 | 186300 | 2020-05-28 | Hidalgo | New Mexico | 35023 | 1 | 0 |
187161 | 187161 | 2020-05-28 | Hidalgo | Texas | 48215 | 548 | 10 |
189360 | 189360 | 2020-05-29 | Hidalgo | New Mexico | 35023 | 1 | 0 |
190225 | 190225 | 2020-05-29 | Hidalgo | Texas | 48215 | 548 | 10 |
192424 | 192424 | 2020-05-30 | Hidalgo | New Mexico | 35023 | 1 | 0 |
193290 | 193290 | 2020-05-30 | Hidalgo | Texas | 48215 | 548 | 10 |
195494 | 195494 | 2020-05-31 | Hidalgo | New Mexico | 35023 | 1 | 0 |
196360 | 196360 | 2020-05-31 | Hidalgo | Texas | 48215 | 575 | 10 |
198567 | 198567 | 2020-06-01 | Hidalgo | New Mexico | 35023 | 1 | 0 |
199433 | 199433 | 2020-06-01 | Hidalgo | Texas | 48215 | 584 | 11 |
201641 | 201641 | 2020-06-02 | Hidalgo | New Mexico | 35023 | 1 | 0 |
202508 | 202508 | 2020-06-02 | Hidalgo | Texas | 48215 | 610 | 11 |
204718 | 204718 | 2020-06-03 | Hidalgo | New Mexico | 35023 | 1 | 0 |
205587 | 205587 | 2020-06-03 | Hidalgo | Texas | 48215 | 610 | 11 |
207799 | 207799 | 2020-06-04 | Hidalgo | New Mexico | 35023 | 1 | 0 |
208669 | 208669 | 2020-06-04 | Hidalgo | Texas | 48215 | 679 | 11 |
210881 | 210881 | 2020-06-05 | Hidalgo | New Mexico | 35023 | 1 | 0 |
211753 | 211753 | 2020-06-05 | Hidalgo | Texas | 48215 | 679 | 11 |
213965 | 213965 | 2020-06-06 | Hidalgo | New Mexico | 35023 | 1 | 0 |
214840 | 214840 | 2020-06-06 | Hidalgo | Texas | 48215 | 679 | 11 |
217054 | 217054 | 2020-06-07 | Hidalgo | New Mexico | 35023 | 1 | 0 |
217930 | 217930 | 2020-06-07 | Hidalgo | Texas | 48215 | 733 | 12 |
220146 | 220146 | 2020-06-08 | Hidalgo | New Mexico | 35023 | 1 | 0 |
221022 | 221022 | 2020-06-08 | Hidalgo | Texas | 48215 | 759 | 12 |
223241 | 223241 | 2020-06-09 | Hidalgo | New Mexico | 35023 | 1 | 0 |
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);