ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Cameron" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324488 | 324488 | 2020-07-11 | Cameron | Texas | 48061 | 3854 | 79 |
321307 | 321307 | 2020-07-10 | Cameron | Texas | 48061 | 3496 | 77 |
318129 | 318129 | 2020-07-09 | Cameron | Texas | 48061 | 3246 | 71 |
314956 | 314956 | 2020-07-08 | Cameron | Texas | 48061 | 3120 | 71 |
311782 | 311782 | 2020-07-07 | Cameron | Texas | 48061 | 2880 | 68 |
308613 | 308613 | 2020-07-06 | Cameron | Texas | 48061 | 2779 | 67 |
305445 | 305445 | 2020-07-05 | Cameron | Texas | 48061 | 2779 | 67 |
302281 | 302281 | 2020-07-04 | Cameron | Texas | 48061 | 2779 | 67 |
299117 | 299117 | 2020-07-03 | Cameron | Texas | 48061 | 2692 | 63 |
295957 | 295957 | 2020-07-02 | Cameron | Texas | 48061 | 2510 | 56 |
292802 | 292802 | 2020-07-01 | Cameron | Texas | 48061 | 2399 | 55 |
289649 | 289649 | 2020-06-30 | Cameron | Texas | 48061 | 2296 | 55 |
286499 | 286499 | 2020-06-29 | Cameron | Texas | 48061 | 2183 | 55 |
283353 | 283353 | 2020-06-28 | Cameron | Texas | 48061 | 2183 | 55 |
280207 | 280207 | 2020-06-27 | Cameron | Texas | 48061 | 2183 | 55 |
277059 | 277059 | 2020-06-26 | Cameron | Texas | 48061 | 1972 | 52 |
273912 | 273912 | 2020-06-25 | Cameron | Texas | 48061 | 1881 | 52 |
270773 | 270773 | 2020-06-24 | Cameron | Texas | 48061 | 1758 | 50 |
267639 | 267639 | 2020-06-23 | Cameron | Texas | 48061 | 1647 | 49 |
264511 | 264511 | 2020-06-22 | Cameron | Texas | 48061 | 1546 | 48 |
261383 | 261383 | 2020-06-21 | Cameron | Texas | 48061 | 1546 | 48 |
258256 | 258256 | 2020-06-20 | Cameron | Texas | 48061 | 1546 | 48 |
255130 | 255130 | 2020-06-19 | Cameron | Texas | 48061 | 1371 | 48 |
252015 | 252015 | 2020-06-18 | Cameron | Texas | 48061 | 1301 | 47 |
248900 | 248900 | 2020-06-17 | Cameron | Texas | 48061 | 1236 | 45 |
245787 | 245787 | 2020-06-16 | Cameron | Texas | 48061 | 1178 | 44 |
242675 | 242675 | 2020-06-15 | Cameron | Texas | 48061 | 1138 | 44 |
239565 | 239565 | 2020-06-14 | Cameron | Texas | 48061 | 1138 | 44 |
236457 | 236457 | 2020-06-13 | Cameron | Texas | 48061 | 1081 | 44 |
233351 | 233351 | 2020-06-12 | Cameron | Texas | 48061 | 1031 | 44 |
230247 | 230247 | 2020-06-11 | Cameron | Texas | 48061 | 990 | 42 |
227143 | 227143 | 2020-06-10 | Cameron | Texas | 48061 | 951 | 40 |
224043 | 224043 | 2020-06-09 | Cameron | Texas | 48061 | 919 | 39 |
220948 | 220948 | 2020-06-08 | Cameron | Texas | 48061 | 892 | 39 |
217856 | 217856 | 2020-06-07 | Cameron | Texas | 48061 | 892 | 39 |
214766 | 214766 | 2020-06-06 | Cameron | Texas | 48061 | 892 | 39 |
211679 | 211679 | 2020-06-05 | Cameron | Texas | 48061 | 841 | 39 |
208596 | 208596 | 2020-06-04 | Cameron | Texas | 48061 | 820 | 39 |
205514 | 205514 | 2020-06-03 | Cameron | Texas | 48061 | 799 | 36 |
202435 | 202435 | 2020-06-02 | Cameron | Texas | 48061 | 776 | 36 |
199360 | 199360 | 2020-06-01 | Cameron | Texas | 48061 | 764 | 36 |
196287 | 196287 | 2020-05-31 | Cameron | Texas | 48061 | 764 | 36 |
193217 | 193217 | 2020-05-30 | Cameron | Texas | 48061 | 754 | 36 |
190152 | 190152 | 2020-05-29 | Cameron | Texas | 48061 | 743 | 35 |
187088 | 187088 | 2020-05-28 | Cameron | Texas | 48061 | 731 | 33 |
184031 | 184031 | 2020-05-27 | Cameron | Texas | 48061 | 711 | 33 |
180981 | 180981 | 2020-05-26 | Cameron | Texas | 48061 | 698 | 33 |
177938 | 177938 | 2020-05-25 | Cameron | Texas | 48061 | 698 | 33 |
174894 | 174894 | 2020-05-24 | Cameron | Texas | 48061 | 698 | 33 |
171851 | 171851 | 2020-05-23 | Cameron | Texas | 48061 | 686 | 32 |
168812 | 168812 | 2020-05-22 | Cameron | Texas | 48061 | 671 | 32 |
165776 | 165776 | 2020-05-21 | Cameron | Texas | 48061 | 664 | 32 |
162747 | 162747 | 2020-05-20 | Cameron | Texas | 48061 | 664 | 32 |
159720 | 159720 | 2020-05-19 | Cameron | Texas | 48061 | 649 | 30 |
156698 | 156698 | 2020-05-18 | Cameron | Texas | 48061 | 619 | 27 |
153681 | 153681 | 2020-05-17 | Cameron | Texas | 48061 | 619 | 27 |
150670 | 150670 | 2020-05-16 | Cameron | Texas | 48061 | 582 | 26 |
147662 | 147662 | 2020-05-15 | Cameron | Texas | 48061 | 582 | 26 |
144660 | 144660 | 2020-05-14 | Cameron | Texas | 48061 | 582 | 26 |
141663 | 141663 | 2020-05-13 | Cameron | Texas | 48061 | 544 | 25 |
138667 | 138667 | 2020-05-12 | Cameron | Texas | 48061 | 527 | 23 |
135677 | 135677 | 2020-05-11 | Cameron | Texas | 48061 | 527 | 23 |
132686 | 132686 | 2020-05-10 | Cameron | Texas | 48061 | 512 | 22 |
129696 | 129696 | 2020-05-09 | Cameron | Texas | 48061 | 494 | 22 |
126707 | 126707 | 2020-05-08 | Cameron | Texas | 48061 | 483 | 20 |
123724 | 123724 | 2020-05-07 | Cameron | Texas | 48061 | 483 | 20 |
120745 | 120745 | 2020-05-06 | Cameron | Texas | 48061 | 469 | 19 |
117781 | 117781 | 2020-05-05 | Cameron | Texas | 48061 | 443 | 18 |
114824 | 114824 | 2020-05-04 | Cameron | Texas | 48061 | 443 | 18 |
111942 | 111942 | 2020-05-03 | Cameron | Texas | 48061 | 432 | 18 |
109068 | 109068 | 2020-05-02 | Cameron | Texas | 48061 | 421 | 18 |
106200 | 106200 | 2020-05-01 | Cameron | Texas | 48061 | 412 | 18 |
103336 | 103336 | 2020-04-30 | Cameron | Texas | 48061 | 401 | 17 |
100483 | 100483 | 2020-04-29 | Cameron | Texas | 48061 | 401 | 16 |
97633 | 97633 | 2020-04-28 | Cameron | Texas | 48061 | 376 | 14 |
94793 | 94793 | 2020-04-27 | Cameron | Texas | 48061 | 376 | 14 |
91965 | 91965 | 2020-04-26 | Cameron | Texas | 48061 | 366 | 14 |
89148 | 89148 | 2020-04-25 | Cameron | Texas | 48061 | 354 | 14 |
86333 | 86333 | 2020-04-24 | Cameron | Texas | 48061 | 344 | 14 |
83528 | 83528 | 2020-04-23 | Cameron | Texas | 48061 | 333 | 12 |
80729 | 80729 | 2020-04-22 | Cameron | Texas | 48061 | 321 | 9 |
77938 | 77938 | 2020-04-21 | Cameron | Texas | 48061 | 310 | 7 |
75156 | 75156 | 2020-04-20 | Cameron | Texas | 48061 | 298 | 6 |
72381 | 72381 | 2020-04-19 | Cameron | Texas | 48061 | 298 | 6 |
69614 | 69614 | 2020-04-18 | Cameron | Texas | 48061 | 298 | 6 |
66855 | 66855 | 2020-04-17 | Cameron | Texas | 48061 | 279 | 5 |
64108 | 64108 | 2020-04-16 | Cameron | Texas | 48061 | 254 | 3 |
61381 | 61381 | 2020-04-15 | Cameron | Texas | 48061 | 239 | 3 |
58664 | 58664 | 2020-04-14 | Cameron | Texas | 48061 | 216 | 3 |
55960 | 55960 | 2020-04-13 | Cameron | Texas | 48061 | 195 | 3 |
53272 | 53272 | 2020-04-12 | Cameron | Texas | 48061 | 195 | 3 |
50597 | 50597 | 2020-04-11 | Cameron | Texas | 48061 | 159 | 3 |
47940 | 47940 | 2020-04-10 | Cameron | Texas | 48061 | 147 | 3 |
45322 | 45322 | 2020-04-09 | Cameron | Texas | 48061 | 126 | 3 |
42733 | 42733 | 2020-04-08 | Cameron | Texas | 48061 | 108 | 0 |
40170 | 40170 | 2020-04-07 | Cameron | Texas | 48061 | 101 | 0 |
37647 | 37647 | 2020-04-06 | Cameron | Texas | 48061 | 87 | 0 |
35171 | 35171 | 2020-04-05 | Cameron | Texas | 48061 | 77 | 0 |
32733 | 32733 | 2020-04-04 | Cameron | Texas | 48061 | 62 | 0 |
30340 | 30340 | 2020-04-03 | Cameron | Texas | 48061 | 55 | 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);