ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 48201 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
574 | 574 | 2020-03-05 | Harris | Texas | 48201 | 4 | 0 |
643 | 643 | 2020-03-06 | Harris | Texas | 48201 | 5 | 0 |
735 | 735 | 2020-03-07 | Harris | Texas | 48201 | 5 | 0 |
847 | 847 | 2020-03-08 | Harris | Texas | 48201 | 6 | 0 |
977 | 977 | 2020-03-09 | Harris | Texas | 48201 | 6 | 0 |
1136 | 1136 | 2020-03-10 | Harris | Texas | 48201 | 7 | 0 |
1333 | 1333 | 2020-03-11 | Harris | Texas | 48201 | 7 | 0 |
1580 | 1580 | 2020-03-12 | Harris | Texas | 48201 | 9 | 0 |
1887 | 1887 | 2020-03-13 | Harris | Texas | 48201 | 10 | 0 |
2253 | 2253 | 2020-03-14 | Harris | Texas | 48201 | 11 | 0 |
2679 | 2679 | 2020-03-15 | Harris | Texas | 48201 | 13 | 0 |
3147 | 3147 | 2020-03-16 | Harris | Texas | 48201 | 13 | 0 |
3682 | 3682 | 2020-03-17 | Harris | Texas | 48201 | 16 | 0 |
4305 | 4305 | 2020-03-18 | Harris | Texas | 48201 | 28 | 0 |
5059 | 5059 | 2020-03-19 | Harris | Texas | 48201 | 35 | 1 |
5951 | 5951 | 2020-03-20 | Harris | Texas | 48201 | 55 | 1 |
6971 | 6971 | 2020-03-21 | Harris | Texas | 48201 | 68 | 1 |
8101 | 8101 | 2020-03-22 | Harris | Texas | 48201 | 74 | 1 |
9319 | 9319 | 2020-03-23 | Harris | Texas | 48201 | 78 | 1 |
10657 | 10657 | 2020-03-24 | Harris | Texas | 48201 | 134 | 1 |
12150 | 12150 | 2020-03-25 | Harris | Texas | 48201 | 185 | 1 |
13779 | 13779 | 2020-03-26 | Harris | Texas | 48201 | 203 | 2 |
15533 | 15533 | 2020-03-27 | Harris | Texas | 48201 | 229 | 2 |
17402 | 17402 | 2020-03-28 | Harris | Texas | 48201 | 445 | 3 |
19355 | 19355 | 2020-03-29 | Harris | Texas | 48201 | 526 | 4 |
21414 | 21414 | 2020-03-30 | Harris | Texas | 48201 | 563 | 7 |
23553 | 23553 | 2020-03-31 | Harris | Texas | 48201 | 680 | 6 |
25763 | 25763 | 2020-04-01 | Harris | Texas | 48201 | 847 | 6 |
28046 | 28046 | 2020-04-02 | Harris | Texas | 48201 | 895 | 10 |
30381 | 30381 | 2020-04-03 | Harris | Texas | 48201 | 1036 | 12 |
32774 | 32774 | 2020-04-04 | Harris | Texas | 48201 | 1284 | 17 |
35212 | 35212 | 2020-04-05 | Harris | Texas | 48201 | 1395 | 20 |
37688 | 37688 | 2020-04-06 | Harris | Texas | 48201 | 1809 | 22 |
40215 | 40215 | 2020-04-07 | Harris | Texas | 48201 | 2146 | 23 |
42782 | 42782 | 2020-04-08 | Harris | Texas | 48201 | 2341 | 31 |
45371 | 45371 | 2020-04-09 | Harris | Texas | 48201 | 3047 | 34 |
47991 | 47991 | 2020-04-10 | Harris | Texas | 48201 | 3261 | 40 |
50649 | 50649 | 2020-04-11 | Harris | Texas | 48201 | 3561 | 41 |
53324 | 53324 | 2020-04-12 | Harris | Texas | 48201 | 3629 | 44 |
56012 | 56012 | 2020-04-13 | Harris | Texas | 48201 | 3747 | 46 |
58717 | 58717 | 2020-04-14 | Harris | Texas | 48201 | 3907 | 52 |
61435 | 61435 | 2020-04-15 | Harris | Texas | 48201 | 4097 | 58 |
64162 | 64162 | 2020-04-16 | Harris | Texas | 48201 | 4306 | 63 |
66909 | 66909 | 2020-04-17 | Harris | Texas | 48201 | 4460 | 67 |
69669 | 69669 | 2020-04-18 | Harris | Texas | 48201 | 4653 | 71 |
72437 | 72437 | 2020-04-19 | Harris | Texas | 48201 | 4823 | 75 |
75212 | 75212 | 2020-04-20 | Harris | Texas | 48201 | 4977 | 78 |
77994 | 77994 | 2020-04-21 | Harris | Texas | 48201 | 5143 | 79 |
80785 | 80785 | 2020-04-22 | Harris | Texas | 48201 | 5211 | 80 |
83585 | 83585 | 2020-04-23 | Harris | Texas | 48201 | 5330 | 82 |
86390 | 86390 | 2020-04-24 | Harris | Texas | 48201 | 5482 | 84 |
89205 | 89205 | 2020-04-25 | Harris | Texas | 48201 | 5628 | 89 |
92022 | 92022 | 2020-04-26 | Harris | Texas | 48201 | 5729 | 93 |
94851 | 94851 | 2020-04-27 | Harris | Texas | 48201 | 5827 | 98 |
97691 | 97691 | 2020-04-28 | Harris | Texas | 48201 | 5986 | 103 |
100541 | 100541 | 2020-04-29 | Harris | Texas | 48201 | 6161 | 109 |
103396 | 103396 | 2020-04-30 | Harris | Texas | 48201 | 6356 | 114 |
106260 | 106260 | 2020-05-01 | Harris | Texas | 48201 | 6551 | 122 |
109129 | 109129 | 2020-05-02 | Harris | Texas | 48201 | 6708 | 129 |
112003 | 112003 | 2020-05-03 | Harris | Texas | 48201 | 6838 | 133 |
114885 | 114885 | 2020-05-04 | Harris | Texas | 48201 | 6967 | 140 |
117844 | 117844 | 2020-05-05 | Harris | Texas | 48201 | 7128 | 144 |
120808 | 120808 | 2020-05-06 | Harris | Texas | 48201 | 7244 | 150 |
123787 | 123787 | 2020-05-07 | Harris | Texas | 48201 | 7377 | 154 |
126770 | 126770 | 2020-05-08 | Harris | Texas | 48201 | 7594 | 160 |
129759 | 129759 | 2020-05-09 | Harris | Texas | 48201 | 7803 | 168 |
132749 | 132749 | 2020-05-10 | Harris | Texas | 48201 | 7878 | 172 |
135740 | 135740 | 2020-05-11 | Harris | Texas | 48201 | 8176 | 179 |
138730 | 138730 | 2020-05-12 | Harris | Texas | 48201 | 8416 | 183 |
141726 | 141726 | 2020-05-13 | Harris | Texas | 48201 | 8621 | 188 |
144723 | 144723 | 2020-05-14 | Harris | Texas | 48201 | 8817 | 193 |
147726 | 147726 | 2020-05-15 | Harris | Texas | 48201 | 9050 | 193 |
150734 | 150734 | 2020-05-16 | Harris | Texas | 48201 | 9126 | 204 |
153745 | 153745 | 2020-05-17 | Harris | Texas | 48201 | 9465 | 204 |
156762 | 156762 | 2020-05-18 | Harris | Texas | 48201 | 9635 | 205 |
159784 | 159784 | 2020-05-19 | Harris | Texas | 48201 | 9859 | 207 |
162812 | 162812 | 2020-05-20 | Harris | Texas | 48201 | 10095 | 210 |
165841 | 165841 | 2020-05-21 | Harris | Texas | 48201 | 10283 | 216 |
168877 | 168877 | 2020-05-22 | Harris | Texas | 48201 | 10526 | 217 |
171917 | 171917 | 2020-05-23 | Harris | Texas | 48201 | 10770 | 219 |
174960 | 174960 | 2020-05-24 | Harris | Texas | 48201 | 10921 | 220 |
178004 | 178004 | 2020-05-25 | Harris | Texas | 48201 | 10921 | 220 |
181047 | 181047 | 2020-05-26 | Harris | Texas | 48201 | 11281 | 221 |
184097 | 184097 | 2020-05-27 | Harris | Texas | 48201 | 11542 | 223 |
187154 | 187154 | 2020-05-28 | Harris | Texas | 48201 | 11770 | 224 |
190218 | 190218 | 2020-05-29 | Harris | Texas | 48201 | 12009 | 228 |
193283 | 193283 | 2020-05-30 | Harris | Texas | 48201 | 12220 | 231 |
196353 | 196353 | 2020-05-31 | Harris | Texas | 48201 | 12276 | 232 |
199426 | 199426 | 2020-06-01 | Harris | Texas | 48201 | 12664 | 235 |
202501 | 202501 | 2020-06-02 | Harris | Texas | 48201 | 13027 | 236 |
205580 | 205580 | 2020-06-03 | Harris | Texas | 48201 | 13268 | 241 |
208662 | 208662 | 2020-06-04 | Harris | Texas | 48201 | 13603 | 247 |
211746 | 211746 | 2020-06-05 | Harris | Texas | 48201 | 13940 | 253 |
214833 | 214833 | 2020-06-06 | Harris | Texas | 48201 | 14423 | 259 |
217923 | 217923 | 2020-06-07 | Harris | Texas | 48201 | 14586 | 261 |
221015 | 221015 | 2020-06-08 | Harris | Texas | 48201 | 14918 | 262 |
224110 | 224110 | 2020-06-09 | Harris | Texas | 48201 | 15238 | 262 |
227210 | 227210 | 2020-06-10 | Harris | Texas | 48201 | 15552 | 267 |
230314 | 230314 | 2020-06-11 | Harris | Texas | 48201 | 15864 | 267 |
233418 | 233418 | 2020-06-12 | Harris | Texas | 48201 | 16188 | 271 |
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);