ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Mesa" and state = "Colorado" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1986 | 1986 | 2020-03-14 | Mesa | Colorado | 8077 | 1 | 0 |
2368 | 2368 | 2020-03-15 | Mesa | Colorado | 8077 | 1 | 0 |
2803 | 2803 | 2020-03-16 | Mesa | Colorado | 8077 | 1 | 0 |
3285 | 3285 | 2020-03-17 | Mesa | Colorado | 8077 | 1 | 0 |
3839 | 3839 | 2020-03-18 | Mesa | Colorado | 8077 | 1 | 0 |
4501 | 4501 | 2020-03-19 | Mesa | Colorado | 8077 | 1 | 0 |
5277 | 5277 | 2020-03-20 | Mesa | Colorado | 8077 | 1 | 0 |
6203 | 6203 | 2020-03-21 | Mesa | Colorado | 8077 | 1 | 0 |
7238 | 7238 | 2020-03-22 | Mesa | Colorado | 8077 | 2 | 0 |
8383 | 8383 | 2020-03-23 | Mesa | Colorado | 8077 | 2 | 0 |
9628 | 9628 | 2020-03-24 | Mesa | Colorado | 8077 | 5 | 0 |
11001 | 11001 | 2020-03-25 | Mesa | Colorado | 8077 | 5 | 0 |
12547 | 12547 | 2020-03-26 | Mesa | Colorado | 8077 | 6 | 0 |
14216 | 14216 | 2020-03-27 | Mesa | Colorado | 8077 | 7 | 0 |
15999 | 15999 | 2020-03-28 | Mesa | Colorado | 8077 | 7 | 0 |
17889 | 17889 | 2020-03-29 | Mesa | Colorado | 8077 | 11 | 0 |
19867 | 19867 | 2020-03-30 | Mesa | Colorado | 8077 | 12 | 0 |
21943 | 21943 | 2020-03-31 | Mesa | Colorado | 8077 | 14 | 0 |
24102 | 24102 | 2020-04-01 | Mesa | Colorado | 8077 | 14 | 0 |
26332 | 26332 | 2020-04-02 | Mesa | Colorado | 8077 | 17 | 0 |
28633 | 28633 | 2020-04-03 | Mesa | Colorado | 8077 | 20 | 0 |
30990 | 30990 | 2020-04-04 | Mesa | Colorado | 8077 | 20 | 0 |
33396 | 33396 | 2020-04-05 | Mesa | Colorado | 8077 | 22 | 0 |
35841 | 35841 | 2020-04-06 | Mesa | Colorado | 8077 | 25 | 0 |
38331 | 38331 | 2020-04-07 | Mesa | Colorado | 8077 | 27 | 0 |
40874 | 40874 | 2020-04-08 | Mesa | Colorado | 8077 | 32 | 0 |
43447 | 43447 | 2020-04-09 | Mesa | Colorado | 8077 | 32 | 0 |
46047 | 46047 | 2020-04-10 | Mesa | Colorado | 8077 | 34 | 0 |
48677 | 48677 | 2020-04-11 | Mesa | Colorado | 8077 | 34 | 0 |
51339 | 51339 | 2020-04-12 | Mesa | Colorado | 8077 | 35 | 0 |
54018 | 54018 | 2020-04-13 | Mesa | Colorado | 8077 | 35 | 0 |
56710 | 56710 | 2020-04-14 | Mesa | Colorado | 8077 | 35 | 0 |
59418 | 59418 | 2020-04-15 | Mesa | Colorado | 8077 | 34 | 0 |
62137 | 62137 | 2020-04-16 | Mesa | Colorado | 8077 | 34 | 0 |
64870 | 64870 | 2020-04-17 | Mesa | Colorado | 8077 | 34 | 0 |
67618 | 67618 | 2020-04-18 | Mesa | Colorado | 8077 | 34 | 0 |
70380 | 70380 | 2020-04-19 | Mesa | Colorado | 8077 | 35 | 0 |
73149 | 73149 | 2020-04-20 | Mesa | Colorado | 8077 | 35 | 0 |
75925 | 75925 | 2020-04-21 | Mesa | Colorado | 8077 | 35 | 0 |
78709 | 78709 | 2020-04-22 | Mesa | Colorado | 8077 | 37 | 0 |
81503 | 81503 | 2020-04-23 | Mesa | Colorado | 8077 | 37 | 0 |
84303 | 84303 | 2020-04-24 | Mesa | Colorado | 8077 | 37 | 0 |
87111 | 87111 | 2020-04-25 | Mesa | Colorado | 8077 | 38 | 0 |
89928 | 89928 | 2020-04-26 | Mesa | Colorado | 8077 | 38 | 0 |
92746 | 92746 | 2020-04-27 | Mesa | Colorado | 8077 | 40 | 0 |
95578 | 95578 | 2020-04-28 | Mesa | Colorado | 8077 | 42 | 0 |
98423 | 98423 | 2020-04-29 | Mesa | Colorado | 8077 | 44 | 0 |
101273 | 101273 | 2020-04-30 | Mesa | Colorado | 8077 | 46 | 0 |
104128 | 104128 | 2020-05-01 | Mesa | Colorado | 8077 | 47 | 0 |
106993 | 106993 | 2020-05-02 | Mesa | Colorado | 8077 | 47 | 0 |
109862 | 109862 | 2020-05-03 | Mesa | Colorado | 8077 | 47 | 0 |
112737 | 112737 | 2020-05-04 | Mesa | Colorado | 8077 | 46 | 0 |
115620 | 115620 | 2020-05-05 | Mesa | Colorado | 8077 | 46 | 0 |
118579 | 118579 | 2020-05-06 | Mesa | Colorado | 8077 | 48 | 0 |
121548 | 121548 | 2020-05-07 | Mesa | Colorado | 8077 | 48 | 0 |
124528 | 124528 | 2020-05-08 | Mesa | Colorado | 8077 | 50 | 0 |
127514 | 127514 | 2020-05-09 | Mesa | Colorado | 8077 | 51 | 0 |
130505 | 130505 | 2020-05-10 | Mesa | Colorado | 8077 | 51 | 0 |
133496 | 133496 | 2020-05-11 | Mesa | Colorado | 8077 | 51 | 0 |
136485 | 136485 | 2020-05-12 | Mesa | Colorado | 8077 | 51 | 0 |
139476 | 139476 | 2020-05-13 | Mesa | Colorado | 8077 | 51 | 0 |
142472 | 142472 | 2020-05-14 | Mesa | Colorado | 8077 | 51 | 0 |
145472 | 145472 | 2020-05-15 | Mesa | Colorado | 8077 | 50 | 0 |
148475 | 148475 | 2020-05-16 | Mesa | Colorado | 8077 | 50 | 0 |
151484 | 151484 | 2020-05-17 | Mesa | Colorado | 8077 | 50 | 0 |
154496 | 154496 | 2020-05-18 | Mesa | Colorado | 8077 | 50 | 0 |
157512 | 157512 | 2020-05-19 | Mesa | Colorado | 8077 | 50 | 0 |
160538 | 160538 | 2020-05-20 | Mesa | Colorado | 8077 | 50 | 0 |
163566 | 163566 | 2020-05-21 | Mesa | Colorado | 8077 | 50 | 0 |
166599 | 166599 | 2020-05-22 | Mesa | Colorado | 8077 | 50 | 0 |
169636 | 169636 | 2020-05-23 | Mesa | Colorado | 8077 | 54 | 0 |
172677 | 172677 | 2020-05-24 | Mesa | Colorado | 8077 | 55 | 0 |
175721 | 175721 | 2020-05-25 | Mesa | Colorado | 8077 | 55 | 0 |
178765 | 178765 | 2020-05-26 | Mesa | Colorado | 8077 | 55 | 0 |
181809 | 181809 | 2020-05-27 | Mesa | Colorado | 8077 | 55 | 0 |
184863 | 184863 | 2020-05-28 | Mesa | Colorado | 8077 | 55 | 0 |
187919 | 187919 | 2020-05-29 | Mesa | Colorado | 8077 | 55 | 0 |
190984 | 190984 | 2020-05-30 | Mesa | Colorado | 8077 | 54 | 0 |
194051 | 194051 | 2020-05-31 | Mesa | Colorado | 8077 | 54 | 0 |
197121 | 197121 | 2020-06-01 | Mesa | Colorado | 8077 | 55 | 0 |
200194 | 200194 | 2020-06-02 | Mesa | Colorado | 8077 | 55 | 0 |
203270 | 203270 | 2020-06-03 | Mesa | Colorado | 8077 | 56 | 0 |
206350 | 206350 | 2020-06-04 | Mesa | Colorado | 8077 | 59 | 0 |
209431 | 209431 | 2020-06-05 | Mesa | Colorado | 8077 | 60 | 0 |
212516 | 212516 | 2020-06-06 | Mesa | Colorado | 8077 | 62 | 0 |
215603 | 215603 | 2020-06-07 | Mesa | Colorado | 8077 | 62 | 0 |
218694 | 218694 | 2020-06-08 | Mesa | Colorado | 8077 | 62 | 0 |
221789 | 221789 | 2020-06-09 | Mesa | Colorado | 8077 | 64 | 0 |
224884 | 224884 | 2020-06-10 | Mesa | Colorado | 8077 | 65 | 0 |
227986 | 227986 | 2020-06-11 | Mesa | Colorado | 8077 | 65 | 0 |
231089 | 231089 | 2020-06-12 | Mesa | Colorado | 8077 | 66 | 0 |
234195 | 234195 | 2020-06-13 | Mesa | Colorado | 8077 | 66 | 0 |
237302 | 237302 | 2020-06-14 | Mesa | Colorado | 8077 | 69 | 0 |
240410 | 240410 | 2020-06-15 | Mesa | Colorado | 8077 | 72 | 0 |
243521 | 243521 | 2020-06-16 | Mesa | Colorado | 8077 | 81 | 0 |
246634 | 246634 | 2020-06-17 | Mesa | Colorado | 8077 | 73 | 0 |
249746 | 249746 | 2020-06-18 | Mesa | Colorado | 8077 | 77 | 0 |
252861 | 252861 | 2020-06-19 | Mesa | Colorado | 8077 | 78 | 0 |
255980 | 255980 | 2020-06-20 | Mesa | Colorado | 8077 | 79 | 0 |
259107 | 259107 | 2020-06-21 | Mesa | Colorado | 8077 | 79 | 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);