ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Crane" and state = "Texas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5050 | 5050 | 2020-03-19 | Crane | Texas | 48103 | 1 | 0 |
5941 | 5941 | 2020-03-20 | Crane | Texas | 48103 | 1 | 0 |
6960 | 6960 | 2020-03-21 | Crane | Texas | 48103 | 1 | 0 |
8090 | 8090 | 2020-03-22 | Crane | Texas | 48103 | 1 | 0 |
9308 | 9308 | 2020-03-23 | Crane | Texas | 48103 | 1 | 0 |
10644 | 10644 | 2020-03-24 | Crane | Texas | 48103 | 1 | 0 |
12129 | 12129 | 2020-03-25 | Crane | Texas | 48103 | 1 | 0 |
13758 | 13758 | 2020-03-26 | Crane | Texas | 48103 | 1 | 0 |
15512 | 15512 | 2020-03-27 | Crane | Texas | 48103 | 1 | 0 |
17381 | 17381 | 2020-03-28 | Crane | Texas | 48103 | 1 | 0 |
19331 | 19331 | 2020-03-29 | Crane | Texas | 48103 | 1 | 0 |
21390 | 21390 | 2020-03-30 | Crane | Texas | 48103 | 1 | 0 |
23529 | 23529 | 2020-03-31 | Crane | Texas | 48103 | 1 | 0 |
25737 | 25737 | 2020-04-01 | Crane | Texas | 48103 | 2 | 0 |
28017 | 28017 | 2020-04-02 | Crane | Texas | 48103 | 2 | 0 |
30352 | 30352 | 2020-04-03 | Crane | Texas | 48103 | 2 | 0 |
32745 | 32745 | 2020-04-04 | Crane | Texas | 48103 | 2 | 0 |
35183 | 35183 | 2020-04-05 | Crane | Texas | 48103 | 2 | 0 |
37659 | 37659 | 2020-04-06 | Crane | Texas | 48103 | 2 | 0 |
40182 | 40182 | 2020-04-07 | Crane | Texas | 48103 | 2 | 0 |
42745 | 42745 | 2020-04-08 | Crane | Texas | 48103 | 2 | 0 |
45334 | 45334 | 2020-04-09 | Crane | Texas | 48103 | 2 | 0 |
47954 | 47954 | 2020-04-10 | Crane | Texas | 48103 | 2 | 0 |
50611 | 50611 | 2020-04-11 | Crane | Texas | 48103 | 2 | 0 |
53286 | 53286 | 2020-04-12 | Crane | Texas | 48103 | 2 | 0 |
55974 | 55974 | 2020-04-13 | Crane | Texas | 48103 | 2 | 0 |
58678 | 58678 | 2020-04-14 | Crane | Texas | 48103 | 2 | 0 |
61395 | 61395 | 2020-04-15 | Crane | Texas | 48103 | 2 | 0 |
64122 | 64122 | 2020-04-16 | Crane | Texas | 48103 | 2 | 0 |
66869 | 66869 | 2020-04-17 | Crane | Texas | 48103 | 2 | 0 |
69629 | 69629 | 2020-04-18 | Crane | Texas | 48103 | 2 | 0 |
72397 | 72397 | 2020-04-19 | Crane | Texas | 48103 | 2 | 0 |
75172 | 75172 | 2020-04-20 | Crane | Texas | 48103 | 2 | 0 |
77954 | 77954 | 2020-04-21 | Crane | Texas | 48103 | 2 | 0 |
80745 | 80745 | 2020-04-22 | Crane | Texas | 48103 | 2 | 0 |
83545 | 83545 | 2020-04-23 | Crane | Texas | 48103 | 2 | 0 |
86350 | 86350 | 2020-04-24 | Crane | Texas | 48103 | 2 | 0 |
89165 | 89165 | 2020-04-25 | Crane | Texas | 48103 | 2 | 0 |
91982 | 91982 | 2020-04-26 | Crane | Texas | 48103 | 2 | 0 |
94811 | 94811 | 2020-04-27 | Crane | Texas | 48103 | 2 | 0 |
97651 | 97651 | 2020-04-28 | Crane | Texas | 48103 | 2 | 0 |
100501 | 100501 | 2020-04-29 | Crane | Texas | 48103 | 2 | 0 |
103354 | 103354 | 2020-04-30 | Crane | Texas | 48103 | 2 | 0 |
106218 | 106218 | 2020-05-01 | Crane | Texas | 48103 | 2 | 0 |
109087 | 109087 | 2020-05-02 | Crane | Texas | 48103 | 2 | 0 |
111961 | 111961 | 2020-05-03 | Crane | Texas | 48103 | 2 | 0 |
114843 | 114843 | 2020-05-04 | Crane | Texas | 48103 | 2 | 0 |
117802 | 117802 | 2020-05-05 | Crane | Texas | 48103 | 2 | 0 |
120766 | 120766 | 2020-05-06 | Crane | Texas | 48103 | 2 | 0 |
123745 | 123745 | 2020-05-07 | Crane | Texas | 48103 | 2 | 0 |
126728 | 126728 | 2020-05-08 | Crane | Texas | 48103 | 2 | 0 |
129717 | 129717 | 2020-05-09 | Crane | Texas | 48103 | 2 | 0 |
132707 | 132707 | 2020-05-10 | Crane | Texas | 48103 | 2 | 0 |
135698 | 135698 | 2020-05-11 | Crane | Texas | 48103 | 2 | 0 |
138688 | 138688 | 2020-05-12 | Crane | Texas | 48103 | 2 | 0 |
141684 | 141684 | 2020-05-13 | Crane | Texas | 48103 | 2 | 0 |
144681 | 144681 | 2020-05-14 | Crane | Texas | 48103 | 2 | 0 |
147683 | 147683 | 2020-05-15 | Crane | Texas | 48103 | 2 | 0 |
150691 | 150691 | 2020-05-16 | Crane | Texas | 48103 | 2 | 0 |
153702 | 153702 | 2020-05-17 | Crane | Texas | 48103 | 2 | 0 |
156719 | 156719 | 2020-05-18 | Crane | Texas | 48103 | 2 | 0 |
159741 | 159741 | 2020-05-19 | Crane | Texas | 48103 | 2 | 0 |
162768 | 162768 | 2020-05-20 | Crane | Texas | 48103 | 2 | 0 |
165797 | 165797 | 2020-05-21 | Crane | Texas | 48103 | 3 | 0 |
168833 | 168833 | 2020-05-22 | Crane | Texas | 48103 | 3 | 0 |
171872 | 171872 | 2020-05-23 | Crane | Texas | 48103 | 7 | 0 |
174915 | 174915 | 2020-05-24 | Crane | Texas | 48103 | 7 | 0 |
177959 | 177959 | 2020-05-25 | Crane | Texas | 48103 | 22 | 0 |
181002 | 181002 | 2020-05-26 | Crane | Texas | 48103 | 22 | 0 |
184052 | 184052 | 2020-05-27 | Crane | Texas | 48103 | 22 | 1 |
187109 | 187109 | 2020-05-28 | Crane | Texas | 48103 | 22 | 2 |
190173 | 190173 | 2020-05-29 | Crane | Texas | 48103 | 22 | 2 |
193238 | 193238 | 2020-05-30 | Crane | Texas | 48103 | 23 | 2 |
196308 | 196308 | 2020-05-31 | Crane | Texas | 48103 | 23 | 2 |
199381 | 199381 | 2020-06-01 | Crane | Texas | 48103 | 23 | 2 |
202456 | 202456 | 2020-06-02 | Crane | Texas | 48103 | 25 | 5 |
205535 | 205535 | 2020-06-03 | Crane | Texas | 48103 | 25 | 5 |
208617 | 208617 | 2020-06-04 | Crane | Texas | 48103 | 25 | 5 |
211700 | 211700 | 2020-06-05 | Crane | Texas | 48103 | 26 | 5 |
214787 | 214787 | 2020-06-06 | Crane | Texas | 48103 | 27 | 5 |
217877 | 217877 | 2020-06-07 | Crane | Texas | 48103 | 27 | 5 |
220969 | 220969 | 2020-06-08 | Crane | Texas | 48103 | 27 | 5 |
224064 | 224064 | 2020-06-09 | Crane | Texas | 48103 | 28 | 5 |
227164 | 227164 | 2020-06-10 | Crane | Texas | 48103 | 31 | 5 |
230268 | 230268 | 2020-06-11 | Crane | Texas | 48103 | 32 | 5 |
233372 | 233372 | 2020-06-12 | Crane | Texas | 48103 | 32 | 5 |
236478 | 236478 | 2020-06-13 | Crane | Texas | 48103 | 32 | 5 |
239586 | 239586 | 2020-06-14 | Crane | Texas | 48103 | 32 | 5 |
242696 | 242696 | 2020-06-15 | Crane | Texas | 48103 | 32 | 5 |
245808 | 245808 | 2020-06-16 | Crane | Texas | 48103 | 39 | 5 |
248921 | 248921 | 2020-06-17 | Crane | Texas | 48103 | 39 | 5 |
252036 | 252036 | 2020-06-18 | Crane | Texas | 48103 | 45 | 5 |
255151 | 255151 | 2020-06-19 | Crane | Texas | 48103 | 45 | 5 |
258277 | 258277 | 2020-06-20 | Crane | Texas | 48103 | 46 | 5 |
261404 | 261404 | 2020-06-21 | Crane | Texas | 48103 | 46 | 5 |
264532 | 264532 | 2020-06-22 | Crane | Texas | 48103 | 47 | 5 |
267660 | 267660 | 2020-06-23 | Crane | Texas | 48103 | 47 | 6 |
270794 | 270794 | 2020-06-24 | Crane | Texas | 48103 | 48 | 6 |
273933 | 273933 | 2020-06-25 | Crane | Texas | 48103 | 49 | 7 |
277080 | 277080 | 2020-06-26 | Crane | Texas | 48103 | 50 | 7 |
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);