ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,954 rows where county = "Phillips" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Phillips · 2,954 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19875 | 19875 | 2020-03-30 | Phillips | Colorado | 8095 | 1 | 0 |
21951 | 21951 | 2020-03-31 | Phillips | Colorado | 8095 | 1 | 0 |
24110 | 24110 | 2020-04-01 | Phillips | Colorado | 8095 | 1 | 0 |
26340 | 26340 | 2020-04-02 | Phillips | Colorado | 8095 | 2 | 0 |
28641 | 28641 | 2020-04-03 | Phillips | Colorado | 8095 | 2 | 0 |
30999 | 30999 | 2020-04-04 | Phillips | Colorado | 8095 | 3 | 0 |
33289 | 33289 | 2020-04-05 | Phillips | Arkansas | 5107 | 1 | 0 |
33405 | 33405 | 2020-04-05 | Phillips | Colorado | 8095 | 3 | 0 |
35733 | 35733 | 2020-04-06 | Phillips | Arkansas | 5107 | 1 | 0 |
35850 | 35850 | 2020-04-06 | Phillips | Colorado | 8095 | 3 | 0 |
38222 | 38222 | 2020-04-07 | Phillips | Arkansas | 5107 | 1 | 0 |
38340 | 38340 | 2020-04-07 | Phillips | Colorado | 8095 | 3 | 0 |
40766 | 40766 | 2020-04-08 | Phillips | Arkansas | 5107 | 1 | 0 |
40883 | 40883 | 2020-04-08 | Phillips | Colorado | 8095 | 4 | 0 |
43338 | 43338 | 2020-04-09 | Phillips | Arkansas | 5107 | 2 | 0 |
43456 | 43456 | 2020-04-09 | Phillips | Colorado | 8095 | 4 | 0 |
45938 | 45938 | 2020-04-10 | Phillips | Arkansas | 5107 | 3 | 0 |
46056 | 46056 | 2020-04-10 | Phillips | Colorado | 8095 | 4 | 0 |
48568 | 48568 | 2020-04-11 | Phillips | Arkansas | 5107 | 3 | 0 |
48686 | 48686 | 2020-04-11 | Phillips | Colorado | 8095 | 4 | 0 |
49278 | 49278 | 2020-04-11 | Phillips | Kansas | 20147 | 1 | 0 |
51230 | 51230 | 2020-04-12 | Phillips | Arkansas | 5107 | 3 | 1 |
51348 | 51348 | 2020-04-12 | Phillips | Colorado | 8095 | 4 | 0 |
51943 | 51943 | 2020-04-12 | Phillips | Kansas | 20147 | 1 | 0 |
53909 | 53909 | 2020-04-13 | Phillips | Arkansas | 5107 | 4 | 1 |
54027 | 54027 | 2020-04-13 | Phillips | Colorado | 8095 | 4 | 0 |
54625 | 54625 | 2020-04-13 | Phillips | Kansas | 20147 | 1 | 0 |
56601 | 56601 | 2020-04-14 | Phillips | Arkansas | 5107 | 4 | 1 |
56719 | 56719 | 2020-04-14 | Phillips | Colorado | 8095 | 4 | 0 |
57319 | 57319 | 2020-04-14 | Phillips | Kansas | 20147 | 1 | 0 |
59309 | 59309 | 2020-04-15 | Phillips | Arkansas | 5107 | 4 | 1 |
59427 | 59427 | 2020-04-15 | Phillips | Colorado | 8095 | 4 | 0 |
60027 | 60027 | 2020-04-15 | Phillips | Kansas | 20147 | 1 | 0 |
62028 | 62028 | 2020-04-16 | Phillips | Arkansas | 5107 | 4 | 1 |
62146 | 62146 | 2020-04-16 | Phillips | Colorado | 8095 | 4 | 0 |
62748 | 62748 | 2020-04-16 | Phillips | Kansas | 20147 | 1 | 0 |
64761 | 64761 | 2020-04-17 | Phillips | Arkansas | 5107 | 4 | 1 |
64879 | 64879 | 2020-04-17 | Phillips | Colorado | 8095 | 5 | 0 |
65484 | 65484 | 2020-04-17 | Phillips | Kansas | 20147 | 1 | 0 |
67509 | 67509 | 2020-04-18 | Phillips | Arkansas | 5107 | 4 | 1 |
67627 | 67627 | 2020-04-18 | Phillips | Colorado | 8095 | 5 | 0 |
68233 | 68233 | 2020-04-18 | Phillips | Kansas | 20147 | 1 | 0 |
70271 | 70271 | 2020-04-19 | Phillips | Arkansas | 5107 | 4 | 1 |
70389 | 70389 | 2020-04-19 | Phillips | Colorado | 8095 | 5 | 0 |
70994 | 70994 | 2020-04-19 | Phillips | Kansas | 20147 | 1 | 0 |
73040 | 73040 | 2020-04-20 | Phillips | Arkansas | 5107 | 4 | 1 |
73158 | 73158 | 2020-04-20 | Phillips | Colorado | 8095 | 5 | 0 |
73766 | 73766 | 2020-04-20 | Phillips | Kansas | 20147 | 1 | 0 |
75816 | 75816 | 2020-04-21 | Phillips | Arkansas | 5107 | 4 | 1 |
75934 | 75934 | 2020-04-21 | Phillips | Colorado | 8095 | 5 | 0 |
76546 | 76546 | 2020-04-21 | Phillips | Kansas | 20147 | 1 | 0 |
78600 | 78600 | 2020-04-22 | Phillips | Arkansas | 5107 | 4 | 1 |
78718 | 78718 | 2020-04-22 | Phillips | Colorado | 8095 | 5 | 0 |
79331 | 79331 | 2020-04-22 | Phillips | Kansas | 20147 | 1 | 0 |
81394 | 81394 | 2020-04-23 | Phillips | Arkansas | 5107 | 4 | 1 |
81512 | 81512 | 2020-04-23 | Phillips | Colorado | 8095 | 5 | 0 |
82126 | 82126 | 2020-04-23 | Phillips | Kansas | 20147 | 1 | 0 |
84194 | 84194 | 2020-04-24 | Phillips | Arkansas | 5107 | 4 | 1 |
84312 | 84312 | 2020-04-24 | Phillips | Colorado | 8095 | 5 | 0 |
84929 | 84929 | 2020-04-24 | Phillips | Kansas | 20147 | 1 | 0 |
87002 | 87002 | 2020-04-25 | Phillips | Arkansas | 5107 | 4 | 1 |
87120 | 87120 | 2020-04-25 | Phillips | Colorado | 8095 | 5 | 0 |
87738 | 87738 | 2020-04-25 | Phillips | Kansas | 20147 | 1 | 0 |
89819 | 89819 | 2020-04-26 | Phillips | Arkansas | 5107 | 4 | 1 |
89937 | 89937 | 2020-04-26 | Phillips | Colorado | 8095 | 5 | 0 |
90554 | 90554 | 2020-04-26 | Phillips | Kansas | 20147 | 1 | 0 |
92637 | 92637 | 2020-04-27 | Phillips | Arkansas | 5107 | 5 | 1 |
92755 | 92755 | 2020-04-27 | Phillips | Colorado | 8095 | 6 | 0 |
93375 | 93375 | 2020-04-27 | Phillips | Kansas | 20147 | 1 | 0 |
95468 | 95468 | 2020-04-28 | Phillips | Arkansas | 5107 | 5 | 1 |
95587 | 95587 | 2020-04-28 | Phillips | Colorado | 8095 | 6 | 0 |
96208 | 96208 | 2020-04-28 | Phillips | Kansas | 20147 | 1 | 0 |
98313 | 98313 | 2020-04-29 | Phillips | Arkansas | 5107 | 5 | 1 |
98432 | 98432 | 2020-04-29 | Phillips | Colorado | 8095 | 6 | 0 |
99054 | 99054 | 2020-04-29 | Phillips | Kansas | 20147 | 1 | 0 |
101163 | 101163 | 2020-04-30 | Phillips | Arkansas | 5107 | 5 | 1 |
101282 | 101282 | 2020-04-30 | Phillips | Colorado | 8095 | 5 | 0 |
101906 | 101906 | 2020-04-30 | Phillips | Kansas | 20147 | 1 | 0 |
104018 | 104018 | 2020-05-01 | Phillips | Arkansas | 5107 | 5 | 1 |
104137 | 104137 | 2020-05-01 | Phillips | Colorado | 8095 | 5 | 0 |
104767 | 104767 | 2020-05-01 | Phillips | Kansas | 20147 | 1 | 0 |
106883 | 106883 | 2020-05-02 | Phillips | Arkansas | 5107 | 5 | 1 |
107002 | 107002 | 2020-05-02 | Phillips | Colorado | 8095 | 5 | 0 |
107632 | 107632 | 2020-05-02 | Phillips | Kansas | 20147 | 1 | 0 |
109752 | 109752 | 2020-05-03 | Phillips | Arkansas | 5107 | 6 | 1 |
109871 | 109871 | 2020-05-03 | Phillips | Colorado | 8095 | 5 | 0 |
110503 | 110503 | 2020-05-03 | Phillips | Kansas | 20147 | 1 | 0 |
112627 | 112627 | 2020-05-04 | Phillips | Arkansas | 5107 | 6 | 1 |
112746 | 112746 | 2020-05-04 | Phillips | Colorado | 8095 | 5 | 0 |
113380 | 113380 | 2020-05-04 | Phillips | Kansas | 20147 | 1 | 0 |
115510 | 115510 | 2020-05-05 | Phillips | Arkansas | 5107 | 5 | 1 |
115629 | 115629 | 2020-05-05 | Phillips | Colorado | 8095 | 5 | 0 |
116262 | 116262 | 2020-05-05 | Phillips | Kansas | 20147 | 1 | 0 |
118469 | 118469 | 2020-05-06 | Phillips | Arkansas | 5107 | 5 | 1 |
118588 | 118588 | 2020-05-06 | Phillips | Colorado | 8095 | 6 | 0 |
119223 | 119223 | 2020-05-06 | Phillips | Kansas | 20147 | 1 | 0 |
121436 | 121436 | 2020-05-07 | Phillips | Arkansas | 5107 | 4 | 1 |
121557 | 121557 | 2020-05-07 | Phillips | Colorado | 8095 | 7 | 0 |
122193 | 122193 | 2020-05-07 | Phillips | Kansas | 20147 | 1 | 0 |
124416 | 124416 | 2020-05-08 | Phillips | Arkansas | 5107 | 4 | 1 |
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);