ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,555 rows where county = "Elbert" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6196 | 6196 | 2020-03-21 | Elbert | Colorado | 8039 | 3 | 0 |
7231 | 7231 | 2020-03-22 | Elbert | Colorado | 8039 | 3 | 0 |
8374 | 8374 | 2020-03-23 | Elbert | Colorado | 8039 | 3 | 0 |
9617 | 9617 | 2020-03-24 | Elbert | Colorado | 8039 | 3 | 0 |
10990 | 10990 | 2020-03-25 | Elbert | Colorado | 8039 | 3 | 0 |
12535 | 12535 | 2020-03-26 | Elbert | Colorado | 8039 | 3 | 0 |
14203 | 14203 | 2020-03-27 | Elbert | Colorado | 8039 | 3 | 0 |
15986 | 15986 | 2020-03-28 | Elbert | Colorado | 8039 | 3 | 0 |
17876 | 17876 | 2020-03-29 | Elbert | Colorado | 8039 | 3 | 0 |
19854 | 19854 | 2020-03-30 | Elbert | Colorado | 8039 | 4 | 0 |
21929 | 21929 | 2020-03-31 | Elbert | Colorado | 8039 | 5 | 0 |
24088 | 24088 | 2020-04-01 | Elbert | Colorado | 8039 | 5 | 0 |
26318 | 26318 | 2020-04-02 | Elbert | Colorado | 8039 | 5 | 0 |
28618 | 28618 | 2020-04-03 | Elbert | Colorado | 8039 | 6 | 0 |
28776 | 28776 | 2020-04-03 | Elbert | Georgia | 13105 | 1 | 0 |
30975 | 30975 | 2020-04-04 | Elbert | Colorado | 8039 | 9 | 1 |
31136 | 31136 | 2020-04-04 | Elbert | Georgia | 13105 | 1 | 0 |
33381 | 33381 | 2020-04-05 | Elbert | Colorado | 8039 | 9 | 1 |
33543 | 33543 | 2020-04-05 | Elbert | Georgia | 13105 | 1 | 0 |
35826 | 35826 | 2020-04-06 | Elbert | Colorado | 8039 | 9 | 1 |
35992 | 35992 | 2020-04-06 | Elbert | Georgia | 13105 | 2 | 0 |
38316 | 38316 | 2020-04-07 | Elbert | Colorado | 8039 | 9 | 1 |
38484 | 38484 | 2020-04-07 | Elbert | Georgia | 13105 | 2 | 0 |
40859 | 40859 | 2020-04-08 | Elbert | Colorado | 8039 | 10 | 1 |
41028 | 41028 | 2020-04-08 | Elbert | Georgia | 13105 | 3 | 0 |
43431 | 43431 | 2020-04-09 | Elbert | Colorado | 8039 | 10 | 1 |
43602 | 43602 | 2020-04-09 | Elbert | Georgia | 13105 | 3 | 0 |
46031 | 46031 | 2020-04-10 | Elbert | Colorado | 8039 | 13 | 1 |
46204 | 46204 | 2020-04-10 | Elbert | Georgia | 13105 | 3 | 0 |
48661 | 48661 | 2020-04-11 | Elbert | Colorado | 8039 | 14 | 1 |
48834 | 48834 | 2020-04-11 | Elbert | Georgia | 13105 | 3 | 0 |
51323 | 51323 | 2020-04-12 | Elbert | Colorado | 8039 | 16 | 1 |
51495 | 51495 | 2020-04-12 | Elbert | Georgia | 13105 | 3 | 0 |
54002 | 54002 | 2020-04-13 | Elbert | Colorado | 8039 | 16 | 1 |
54175 | 54175 | 2020-04-13 | Elbert | Georgia | 13105 | 6 | 0 |
56694 | 56694 | 2020-04-14 | Elbert | Colorado | 8039 | 17 | 1 |
56867 | 56867 | 2020-04-14 | Elbert | Georgia | 13105 | 6 | 0 |
59402 | 59402 | 2020-04-15 | Elbert | Colorado | 8039 | 16 | 1 |
59574 | 59574 | 2020-04-15 | Elbert | Georgia | 13105 | 7 | 0 |
62121 | 62121 | 2020-04-16 | Elbert | Colorado | 8039 | 17 | 1 |
62294 | 62294 | 2020-04-16 | Elbert | Georgia | 13105 | 7 | 0 |
64854 | 64854 | 2020-04-17 | Elbert | Colorado | 8039 | 20 | 1 |
65027 | 65027 | 2020-04-17 | Elbert | Georgia | 13105 | 7 | 0 |
67602 | 67602 | 2020-04-18 | Elbert | Colorado | 8039 | 23 | 1 |
67775 | 67775 | 2020-04-18 | Elbert | Georgia | 13105 | 7 | 0 |
70364 | 70364 | 2020-04-19 | Elbert | Colorado | 8039 | 23 | 1 |
70537 | 70537 | 2020-04-19 | Elbert | Georgia | 13105 | 7 | 0 |
73133 | 73133 | 2020-04-20 | Elbert | Colorado | 8039 | 24 | 1 |
73306 | 73306 | 2020-04-20 | Elbert | Georgia | 13105 | 7 | 0 |
75909 | 75909 | 2020-04-21 | Elbert | Colorado | 8039 | 24 | 1 |
76082 | 76082 | 2020-04-21 | Elbert | Georgia | 13105 | 7 | 0 |
78693 | 78693 | 2020-04-22 | Elbert | Colorado | 8039 | 24 | 1 |
78866 | 78866 | 2020-04-22 | Elbert | Georgia | 13105 | 10 | 0 |
81487 | 81487 | 2020-04-23 | Elbert | Colorado | 8039 | 26 | 1 |
81659 | 81659 | 2020-04-23 | Elbert | Georgia | 13105 | 14 | 0 |
84287 | 84287 | 2020-04-24 | Elbert | Colorado | 8039 | 27 | 1 |
84459 | 84459 | 2020-04-24 | Elbert | Georgia | 13105 | 15 | 0 |
87095 | 87095 | 2020-04-25 | Elbert | Colorado | 8039 | 27 | 1 |
87268 | 87268 | 2020-04-25 | Elbert | Georgia | 13105 | 16 | 0 |
89912 | 89912 | 2020-04-26 | Elbert | Colorado | 8039 | 27 | 1 |
90084 | 90084 | 2020-04-26 | Elbert | Georgia | 13105 | 19 | 0 |
92730 | 92730 | 2020-04-27 | Elbert | Colorado | 8039 | 27 | 1 |
92903 | 92903 | 2020-04-27 | Elbert | Georgia | 13105 | 19 | 0 |
95562 | 95562 | 2020-04-28 | Elbert | Colorado | 8039 | 27 | 1 |
95735 | 95735 | 2020-04-28 | Elbert | Georgia | 13105 | 19 | 0 |
98407 | 98407 | 2020-04-29 | Elbert | Colorado | 8039 | 28 | 1 |
98580 | 98580 | 2020-04-29 | Elbert | Georgia | 13105 | 22 | 0 |
101257 | 101257 | 2020-04-30 | Elbert | Colorado | 8039 | 29 | 1 |
101430 | 101430 | 2020-04-30 | Elbert | Georgia | 13105 | 23 | 0 |
104112 | 104112 | 2020-05-01 | Elbert | Colorado | 8039 | 30 | 1 |
104285 | 104285 | 2020-05-01 | Elbert | Georgia | 13105 | 27 | 0 |
106977 | 106977 | 2020-05-02 | Elbert | Colorado | 8039 | 31 | 1 |
107150 | 107150 | 2020-05-02 | Elbert | Georgia | 13105 | 29 | 0 |
109846 | 109846 | 2020-05-03 | Elbert | Colorado | 8039 | 31 | 1 |
110019 | 110019 | 2020-05-03 | Elbert | Georgia | 13105 | 31 | 0 |
112721 | 112721 | 2020-05-04 | Elbert | Colorado | 8039 | 32 | 1 |
112894 | 112894 | 2020-05-04 | Elbert | Georgia | 13105 | 31 | 0 |
115604 | 115604 | 2020-05-05 | Elbert | Colorado | 8039 | 36 | 1 |
115777 | 115777 | 2020-05-05 | Elbert | Georgia | 13105 | 32 | 0 |
118563 | 118563 | 2020-05-06 | Elbert | Colorado | 8039 | 37 | 1 |
118737 | 118737 | 2020-05-06 | Elbert | Georgia | 13105 | 33 | 0 |
121532 | 121532 | 2020-05-07 | Elbert | Colorado | 8039 | 37 | 1 |
121706 | 121706 | 2020-05-07 | Elbert | Georgia | 13105 | 34 | 0 |
124512 | 124512 | 2020-05-08 | Elbert | Colorado | 8039 | 39 | 1 |
124685 | 124685 | 2020-05-08 | Elbert | Georgia | 13105 | 37 | 0 |
127498 | 127498 | 2020-05-09 | Elbert | Colorado | 8039 | 39 | 1 |
127672 | 127672 | 2020-05-09 | Elbert | Georgia | 13105 | 39 | 0 |
130489 | 130489 | 2020-05-10 | Elbert | Colorado | 8039 | 39 | 1 |
130663 | 130663 | 2020-05-10 | Elbert | Georgia | 13105 | 42 | 0 |
133480 | 133480 | 2020-05-11 | Elbert | Colorado | 8039 | 39 | 1 |
133654 | 133654 | 2020-05-11 | Elbert | Georgia | 13105 | 42 | 0 |
136469 | 136469 | 2020-05-12 | Elbert | Colorado | 8039 | 40 | 2 |
136643 | 136643 | 2020-05-12 | Elbert | Georgia | 13105 | 43 | 0 |
139460 | 139460 | 2020-05-13 | Elbert | Colorado | 8039 | 41 | 2 |
139634 | 139634 | 2020-05-13 | Elbert | Georgia | 13105 | 46 | 0 |
142456 | 142456 | 2020-05-14 | Elbert | Colorado | 8039 | 41 | 2 |
142630 | 142630 | 2020-05-14 | Elbert | Georgia | 13105 | 46 | 0 |
145456 | 145456 | 2020-05-15 | Elbert | Colorado | 8039 | 42 | 2 |
145630 | 145630 | 2020-05-15 | Elbert | Georgia | 13105 | 46 | 0 |
148459 | 148459 | 2020-05-16 | Elbert | Colorado | 8039 | 44 | 2 |
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);