ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Milam" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324619 | 324619 | 2020-07-11 | Milam | Texas | 48331 | 149 | 1 |
321438 | 321438 | 2020-07-10 | Milam | Texas | 48331 | 137 | 1 |
318259 | 318259 | 2020-07-09 | Milam | Texas | 48331 | 133 | 1 |
315086 | 315086 | 2020-07-08 | Milam | Texas | 48331 | 120 | 1 |
311912 | 311912 | 2020-07-07 | Milam | Texas | 48331 | 112 | 1 |
308743 | 308743 | 2020-07-06 | Milam | Texas | 48331 | 92 | 1 |
305575 | 305575 | 2020-07-05 | Milam | Texas | 48331 | 92 | 1 |
302411 | 302411 | 2020-07-04 | Milam | Texas | 48331 | 92 | 1 |
299247 | 299247 | 2020-07-03 | Milam | Texas | 48331 | 92 | 1 |
296086 | 296086 | 2020-07-02 | Milam | Texas | 48331 | 90 | 1 |
292931 | 292931 | 2020-07-01 | Milam | Texas | 48331 | 88 | 1 |
289778 | 289778 | 2020-06-30 | Milam | Texas | 48331 | 83 | 1 |
286628 | 286628 | 2020-06-29 | Milam | Texas | 48331 | 80 | 1 |
283482 | 283482 | 2020-06-28 | Milam | Texas | 48331 | 80 | 1 |
280336 | 280336 | 2020-06-27 | Milam | Texas | 48331 | 80 | 1 |
277188 | 277188 | 2020-06-26 | Milam | Texas | 48331 | 78 | 1 |
274040 | 274040 | 2020-06-25 | Milam | Texas | 48331 | 73 | 1 |
270900 | 270900 | 2020-06-24 | Milam | Texas | 48331 | 68 | 1 |
267766 | 267766 | 2020-06-23 | Milam | Texas | 48331 | 63 | 1 |
264638 | 264638 | 2020-06-22 | Milam | Texas | 48331 | 57 | 1 |
261509 | 261509 | 2020-06-21 | Milam | Texas | 48331 | 57 | 1 |
258382 | 258382 | 2020-06-20 | Milam | Texas | 48331 | 57 | 1 |
255255 | 255255 | 2020-06-19 | Milam | Texas | 48331 | 56 | 1 |
252140 | 252140 | 2020-06-18 | Milam | Texas | 48331 | 51 | 1 |
249025 | 249025 | 2020-06-17 | Milam | Texas | 48331 | 48 | 1 |
245912 | 245912 | 2020-06-16 | Milam | Texas | 48331 | 44 | 1 |
242800 | 242800 | 2020-06-15 | Milam | Texas | 48331 | 44 | 1 |
239690 | 239690 | 2020-06-14 | Milam | Texas | 48331 | 44 | 1 |
236582 | 236582 | 2020-06-13 | Milam | Texas | 48331 | 42 | 1 |
233476 | 233476 | 2020-06-12 | Milam | Texas | 48331 | 40 | 1 |
230372 | 230372 | 2020-06-11 | Milam | Texas | 48331 | 38 | 1 |
227268 | 227268 | 2020-06-10 | Milam | Texas | 48331 | 37 | 1 |
224168 | 224168 | 2020-06-09 | Milam | Texas | 48331 | 35 | 1 |
221073 | 221073 | 2020-06-08 | Milam | Texas | 48331 | 35 | 1 |
217981 | 217981 | 2020-06-07 | Milam | Texas | 48331 | 35 | 1 |
214891 | 214891 | 2020-06-06 | Milam | Texas | 48331 | 35 | 1 |
211804 | 211804 | 2020-06-05 | Milam | Texas | 48331 | 32 | 1 |
208720 | 208720 | 2020-06-04 | Milam | Texas | 48331 | 29 | 1 |
205638 | 205638 | 2020-06-03 | Milam | Texas | 48331 | 29 | 1 |
202559 | 202559 | 2020-06-02 | Milam | Texas | 48331 | 29 | 1 |
199483 | 199483 | 2020-06-01 | Milam | Texas | 48331 | 28 | 1 |
196410 | 196410 | 2020-05-31 | Milam | Texas | 48331 | 28 | 1 |
193340 | 193340 | 2020-05-30 | Milam | Texas | 48331 | 28 | 1 |
190274 | 190274 | 2020-05-29 | Milam | Texas | 48331 | 28 | 1 |
187210 | 187210 | 2020-05-28 | Milam | Texas | 48331 | 28 | 1 |
184153 | 184153 | 2020-05-27 | Milam | Texas | 48331 | 28 | 1 |
181103 | 181103 | 2020-05-26 | Milam | Texas | 48331 | 28 | 1 |
178059 | 178059 | 2020-05-25 | Milam | Texas | 48331 | 28 | 1 |
175015 | 175015 | 2020-05-24 | Milam | Texas | 48331 | 28 | 1 |
171972 | 171972 | 2020-05-23 | Milam | Texas | 48331 | 28 | 1 |
168932 | 168932 | 2020-05-22 | Milam | Texas | 48331 | 27 | 1 |
165896 | 165896 | 2020-05-21 | Milam | Texas | 48331 | 27 | 1 |
162867 | 162867 | 2020-05-20 | Milam | Texas | 48331 | 26 | 1 |
159839 | 159839 | 2020-05-19 | Milam | Texas | 48331 | 25 | 1 |
156817 | 156817 | 2020-05-18 | Milam | Texas | 48331 | 24 | 1 |
153800 | 153800 | 2020-05-17 | Milam | Texas | 48331 | 24 | 1 |
150789 | 150789 | 2020-05-16 | Milam | Texas | 48331 | 23 | 1 |
147781 | 147781 | 2020-05-15 | Milam | Texas | 48331 | 23 | 1 |
144777 | 144777 | 2020-05-14 | Milam | Texas | 48331 | 22 | 1 |
141780 | 141780 | 2020-05-13 | Milam | Texas | 48331 | 20 | 1 |
138784 | 138784 | 2020-05-12 | Milam | Texas | 48331 | 20 | 1 |
135794 | 135794 | 2020-05-11 | Milam | Texas | 48331 | 20 | 1 |
132803 | 132803 | 2020-05-10 | Milam | Texas | 48331 | 20 | 1 |
129813 | 129813 | 2020-05-09 | Milam | Texas | 48331 | 20 | 1 |
126824 | 126824 | 2020-05-08 | Milam | Texas | 48331 | 18 | 1 |
123840 | 123840 | 2020-05-07 | Milam | Texas | 48331 | 18 | 1 |
120861 | 120861 | 2020-05-06 | Milam | Texas | 48331 | 18 | 1 |
117897 | 117897 | 2020-05-05 | Milam | Texas | 48331 | 18 | 1 |
114938 | 114938 | 2020-05-04 | Milam | Texas | 48331 | 18 | 1 |
112056 | 112056 | 2020-05-03 | Milam | Texas | 48331 | 17 | 1 |
109182 | 109182 | 2020-05-02 | Milam | Texas | 48331 | 16 | 1 |
106313 | 106313 | 2020-05-01 | Milam | Texas | 48331 | 16 | 1 |
103449 | 103449 | 2020-04-30 | Milam | Texas | 48331 | 16 | 1 |
100594 | 100594 | 2020-04-29 | Milam | Texas | 48331 | 14 | 1 |
97744 | 97744 | 2020-04-28 | Milam | Texas | 48331 | 14 | 1 |
94903 | 94903 | 2020-04-27 | Milam | Texas | 48331 | 13 | 1 |
92074 | 92074 | 2020-04-26 | Milam | Texas | 48331 | 13 | 1 |
89257 | 89257 | 2020-04-25 | Milam | Texas | 48331 | 13 | 1 |
86442 | 86442 | 2020-04-24 | Milam | Texas | 48331 | 13 | 1 |
83637 | 83637 | 2020-04-23 | Milam | Texas | 48331 | 13 | 0 |
80836 | 80836 | 2020-04-22 | Milam | Texas | 48331 | 12 | 0 |
78045 | 78045 | 2020-04-21 | Milam | Texas | 48331 | 12 | 0 |
75263 | 75263 | 2020-04-20 | Milam | Texas | 48331 | 12 | 0 |
72487 | 72487 | 2020-04-19 | Milam | Texas | 48331 | 11 | 0 |
69718 | 69718 | 2020-04-18 | Milam | Texas | 48331 | 9 | 0 |
66958 | 66958 | 2020-04-17 | Milam | Texas | 48331 | 9 | 0 |
64211 | 64211 | 2020-04-16 | Milam | Texas | 48331 | 8 | 0 |
61482 | 61482 | 2020-04-15 | Milam | Texas | 48331 | 8 | 0 |
58764 | 58764 | 2020-04-14 | Milam | Texas | 48331 | 8 | 0 |
56059 | 56059 | 2020-04-13 | Milam | Texas | 48331 | 8 | 0 |
53371 | 53371 | 2020-04-12 | Milam | Texas | 48331 | 7 | 0 |
50696 | 50696 | 2020-04-11 | Milam | Texas | 48331 | 7 | 0 |
48038 | 48038 | 2020-04-10 | Milam | Texas | 48331 | 7 | 0 |
45417 | 45417 | 2020-04-09 | Milam | Texas | 48331 | 7 | 0 |
42825 | 42825 | 2020-04-08 | Milam | Texas | 48331 | 7 | 0 |
40257 | 40257 | 2020-04-07 | Milam | Texas | 48331 | 3 | 0 |
37729 | 37729 | 2020-04-06 | Milam | Texas | 48331 | 3 | 0 |
35253 | 35253 | 2020-04-05 | Milam | Texas | 48331 | 3 | 0 |
32815 | 32815 | 2020-04-04 | Milam | Texas | 48331 | 2 | 0 |
30419 | 30419 | 2020-04-03 | Milam | Texas | 48331 | 2 | 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);