ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

135 rows where fips = 6023 sorted by date descending

View and edit SQL

Suggested facets: deaths

state

fips

  • 6023 · 135

county

Link rowid date ▲ county state fips cases deaths
291956 2020-07-03 Humboldt California 6023 138 4
288879 2020-07-02 Humboldt California 6023 138 4
285804 2020-07-01 Humboldt California 6023 136 4
282731 2020-06-30 Humboldt California 6023 133 4
279662 2020-06-29 Humboldt California 6023 133 4
276594 2020-06-28 Humboldt California 6023 129 4
273525 2020-06-27 Humboldt California 6023 129 4
270456 2020-06-26 Humboldt California 6023 129 4
267395 2020-06-25 Humboldt California 6023 127 4
264339 2020-06-24 Humboldt California 6023 122 4
261288 2020-06-23 Humboldt California 6023 113 4
258239 2020-06-22 Humboldt California 6023 112 4
255192 2020-06-21 Humboldt California 6023 110 4
252145 2020-06-20 Humboldt California 6023 110 4
249106 2020-06-19 Humboldt California 6023 110 4
246071 2020-06-18 Humboldt California 6023 108 4
243039 2020-06-17 Humboldt California 6023 108 4
240006 2020-06-16 Humboldt California 6023 107 4
236974 2020-06-15 Humboldt California 6023 106 4
233946 2020-06-14 Humboldt California 6023 106 4
230919 2020-06-13 Humboldt California 6023 106 4
227893 2020-06-12 Humboldt California 6023 113 4
224869 2020-06-11 Humboldt California 6023 112 4
221847 2020-06-10 Humboldt California 6023 113 4
218831 2020-06-09 Humboldt California 6023 112 4
215816 2020-06-08 Humboldt California 6023 112 4
212805 2020-06-07 Humboldt California 6023 112 4
209798 2020-06-06 Humboldt California 6023 111 4
206792 2020-06-05 Humboldt California 6023 109 4
203791 2020-06-04 Humboldt California 6023 104 4
200791 2020-06-03 Humboldt California 6023 104 4
197795 2020-06-02 Humboldt California 6023 103 4
194803 2020-06-01 Humboldt California 6023 102 3
191814 2020-05-31 Humboldt California 6023 101 3
188828 2020-05-30 Humboldt California 6023 101 3
185844 2020-05-29 Humboldt California 6023 99 3
182867 2020-05-28 Humboldt California 6023 98 3
179891 2020-05-27 Humboldt California 6023 98 2
176925 2020-05-26 Humboldt California 6023 94 2
173960 2020-05-25 Humboldt California 6023 94 2
170995 2020-05-24 Humboldt California 6023 93 2
168033 2020-05-23 Humboldt California 6023 93 2
165076 2020-05-22 Humboldt California 6023 91 2
162123 2020-05-21 Humboldt California 6023 88 2
159175 2020-05-20 Humboldt California 6023 88 0
156229 2020-05-19 Humboldt California 6023 86 0
153293 2020-05-18 Humboldt California 6023 81 0
150361 2020-05-17 Humboldt California 6023 77 0
147432 2020-05-16 Humboldt California 6023 77 0
144507 2020-05-15 Humboldt California 6023 72 0
141587 2020-05-14 Humboldt California 6023 68 0
138670 2020-05-13 Humboldt California 6023 67 0
135758 2020-05-12 Humboldt California 6023 64 0
132847 2020-05-11 Humboldt California 6023 61 0
129936 2020-05-10 Humboldt California 6023 57 0
127025 2020-05-09 Humboldt California 6023 57 0
124119 2020-05-08 Humboldt California 6023 55 0
121218 2020-05-07 Humboldt California 6023 55 0
118330 2020-05-06 Humboldt California 6023 55 0
115450 2020-05-05 Humboldt California 6023 54 0
112571 2020-05-04 Humboldt California 6023 54 0
109700 2020-05-03 Humboldt California 6023 54 0
106835 2020-05-02 Humboldt California 6023 54 0
103974 2020-05-01 Humboldt California 6023 54 0
101123 2020-04-30 Humboldt California 6023 54 0
98277 2020-04-29 Humboldt California 6023 54 0
95436 2020-04-28 Humboldt California 6023 53 0
92608 2020-04-27 Humboldt California 6023 53 0
89793 2020-04-26 Humboldt California 6023 53 0
86979 2020-04-25 Humboldt California 6023 53 0
84174 2020-04-24 Humboldt California 6023 53 0
81377 2020-04-23 Humboldt California 6023 52 0
78586 2020-04-22 Humboldt California 6023 52 0
75805 2020-04-21 Humboldt California 6023 52 0
73032 2020-04-20 Humboldt California 6023 52 0
70266 2020-04-19 Humboldt California 6023 52 0
67507 2020-04-18 Humboldt California 6023 52 0
64762 2020-04-17 Humboldt California 6023 52 0
62032 2020-04-16 Humboldt California 6023 52 0
59316 2020-04-15 Humboldt California 6023 52 0
56611 2020-04-14 Humboldt California 6023 51 0
53922 2020-04-13 Humboldt California 6023 50 0
51246 2020-04-12 Humboldt California 6023 50 0
48587 2020-04-11 Humboldt California 6023 50 0
45960 2020-04-10 Humboldt California 6023 50 0
43363 2020-04-09 Humboldt California 6023 50 0
40794 2020-04-08 Humboldt California 6023 50 0
38253 2020-04-07 Humboldt California 6023 50 0
35767 2020-04-06 Humboldt California 6023 49 0
33323 2020-04-05 Humboldt California 6023 44 0
30917 2020-04-04 Humboldt California 6023 44 0
28559 2020-04-03 Humboldt California 6023 40 0
26260 2020-04-02 Humboldt California 6023 37 0
24031 2020-04-01 Humboldt California 6023 27 0
21873 2020-03-31 Humboldt California 6023 27 0
19799 2020-03-30 Humboldt California 6023 21 0
17822 2020-03-29 Humboldt California 6023 18 0
15933 2020-03-28 Humboldt California 6023 18 0
14151 2020-03-27 Humboldt California 6023 14 0
12486 2020-03-26 Humboldt California 6023 12 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 987.836ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette