ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Jefferson" and state = "Arkansas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- …
state 1
- Arkansas · 794 ✖
fips 1
- 5069 794
county 1
- Jefferson · 794 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1164 | 1164 | 2020-03-11 | Jefferson | Arkansas | 5069 | 1 | 0 |
1369 | 1369 | 2020-03-12 | Jefferson | Arkansas | 5069 | 1 | 0 |
1629 | 1629 | 2020-03-13 | Jefferson | Arkansas | 5069 | 1 | 0 |
1946 | 1946 | 2020-03-14 | Jefferson | Arkansas | 5069 | 2 | 0 |
2324 | 2324 | 2020-03-15 | Jefferson | Arkansas | 5069 | 5 | 0 |
2757 | 2757 | 2020-03-16 | Jefferson | Arkansas | 5069 | 5 | 0 |
3237 | 3237 | 2020-03-17 | Jefferson | Arkansas | 5069 | 5 | 0 |
3789 | 3789 | 2020-03-18 | Jefferson | Arkansas | 5069 | 10 | 0 |
4442 | 4442 | 2020-03-19 | Jefferson | Arkansas | 5069 | 18 | 0 |
5214 | 5214 | 2020-03-20 | Jefferson | Arkansas | 5069 | 19 | 0 |
6133 | 6133 | 2020-03-21 | Jefferson | Arkansas | 5069 | 19 | 0 |
7167 | 7167 | 2020-03-22 | Jefferson | Arkansas | 5069 | 20 | 0 |
8310 | 8310 | 2020-03-23 | Jefferson | Arkansas | 5069 | 20 | 0 |
9544 | 9544 | 2020-03-24 | Jefferson | Arkansas | 5069 | 22 | 0 |
10915 | 10915 | 2020-03-25 | Jefferson | Arkansas | 5069 | 22 | 0 |
12458 | 12458 | 2020-03-26 | Jefferson | Arkansas | 5069 | 23 | 0 |
14122 | 14122 | 2020-03-27 | Jefferson | Arkansas | 5069 | 23 | 0 |
15902 | 15902 | 2020-03-28 | Jefferson | Arkansas | 5069 | 25 | 0 |
17789 | 17789 | 2020-03-29 | Jefferson | Arkansas | 5069 | 26 | 0 |
19763 | 19763 | 2020-03-30 | Jefferson | Arkansas | 5069 | 33 | 0 |
21835 | 21835 | 2020-03-31 | Jefferson | Arkansas | 5069 | 40 | 0 |
23992 | 23992 | 2020-04-01 | Jefferson | Arkansas | 5069 | 49 | 0 |
26216 | 26216 | 2020-04-02 | Jefferson | Arkansas | 5069 | 49 | 0 |
28513 | 28513 | 2020-04-03 | Jefferson | Arkansas | 5069 | 53 | 0 |
30871 | 30871 | 2020-04-04 | Jefferson | Arkansas | 5069 | 53 | 0 |
33275 | 33275 | 2020-04-05 | Jefferson | Arkansas | 5069 | 62 | 0 |
35718 | 35718 | 2020-04-06 | Jefferson | Arkansas | 5069 | 68 | 1 |
38207 | 38207 | 2020-04-07 | Jefferson | Arkansas | 5069 | 78 | 1 |
40750 | 40750 | 2020-04-08 | Jefferson | Arkansas | 5069 | 85 | 1 |
43322 | 43322 | 2020-04-09 | Jefferson | Arkansas | 5069 | 91 | 1 |
45921 | 45921 | 2020-04-10 | Jefferson | Arkansas | 5069 | 90 | 2 |
48551 | 48551 | 2020-04-11 | Jefferson | Arkansas | 5069 | 91 | 2 |
51213 | 51213 | 2020-04-12 | Jefferson | Arkansas | 5069 | 95 | 3 |
53892 | 53892 | 2020-04-13 | Jefferson | Arkansas | 5069 | 103 | 4 |
56584 | 56584 | 2020-04-14 | Jefferson | Arkansas | 5069 | 105 | 5 |
59292 | 59292 | 2020-04-15 | Jefferson | Arkansas | 5069 | 107 | 6 |
62011 | 62011 | 2020-04-16 | Jefferson | Arkansas | 5069 | 109 | 6 |
64744 | 64744 | 2020-04-17 | Jefferson | Arkansas | 5069 | 113 | 6 |
67492 | 67492 | 2020-04-18 | Jefferson | Arkansas | 5069 | 118 | 6 |
70254 | 70254 | 2020-04-19 | Jefferson | Arkansas | 5069 | 118 | 6 |
73023 | 73023 | 2020-04-20 | Jefferson | Arkansas | 5069 | 126 | 7 |
75799 | 75799 | 2020-04-21 | Jefferson | Arkansas | 5069 | 135 | 7 |
78583 | 78583 | 2020-04-22 | Jefferson | Arkansas | 5069 | 136 | 7 |
81377 | 81377 | 2020-04-23 | Jefferson | Arkansas | 5069 | 142 | 7 |
84177 | 84177 | 2020-04-24 | Jefferson | Arkansas | 5069 | 145 | 7 |
86985 | 86985 | 2020-04-25 | Jefferson | Arkansas | 5069 | 149 | 7 |
89802 | 89802 | 2020-04-26 | Jefferson | Arkansas | 5069 | 153 | 9 |
92620 | 92620 | 2020-04-27 | Jefferson | Arkansas | 5069 | 160 | 9 |
95450 | 95450 | 2020-04-28 | Jefferson | Arkansas | 5069 | 162 | 13 |
98295 | 98295 | 2020-04-29 | Jefferson | Arkansas | 5069 | 168 | 14 |
101145 | 101145 | 2020-04-30 | Jefferson | Arkansas | 5069 | 169 | 14 |
104000 | 104000 | 2020-05-01 | Jefferson | Arkansas | 5069 | 176 | 15 |
106865 | 106865 | 2020-05-02 | Jefferson | Arkansas | 5069 | 178 | 16 |
109734 | 109734 | 2020-05-03 | Jefferson | Arkansas | 5069 | 184 | 17 |
112609 | 112609 | 2020-05-04 | Jefferson | Arkansas | 5069 | 195 | 18 |
115492 | 115492 | 2020-05-05 | Jefferson | Arkansas | 5069 | 199 | 19 |
118451 | 118451 | 2020-05-06 | Jefferson | Arkansas | 5069 | 217 | 19 |
121418 | 121418 | 2020-05-07 | Jefferson | Arkansas | 5069 | 222 | 19 |
124398 | 124398 | 2020-05-08 | Jefferson | Arkansas | 5069 | 226 | 19 |
127383 | 127383 | 2020-05-09 | Jefferson | Arkansas | 5069 | 226 | 19 |
130373 | 130373 | 2020-05-10 | Jefferson | Arkansas | 5069 | 234 | 19 |
133363 | 133363 | 2020-05-11 | Jefferson | Arkansas | 5069 | 238 | 19 |
136353 | 136353 | 2020-05-12 | Jefferson | Arkansas | 5069 | 273 | 19 |
139344 | 139344 | 2020-05-13 | Jefferson | Arkansas | 5069 | 280 | 19 |
142340 | 142340 | 2020-05-14 | Jefferson | Arkansas | 5069 | 300 | 19 |
145339 | 145339 | 2020-05-15 | Jefferson | Arkansas | 5069 | 310 | 19 |
148342 | 148342 | 2020-05-16 | Jefferson | Arkansas | 5069 | 362 | 19 |
151351 | 151351 | 2020-05-17 | Jefferson | Arkansas | 5069 | 491 | 19 |
154363 | 154363 | 2020-05-18 | Jefferson | Arkansas | 5069 | 491 | 19 |
157379 | 157379 | 2020-05-19 | Jefferson | Arkansas | 5069 | 497 | 20 |
160405 | 160405 | 2020-05-20 | Jefferson | Arkansas | 5069 | 499 | 21 |
163433 | 163433 | 2020-05-21 | Jefferson | Arkansas | 5069 | 500 | 22 |
166465 | 166465 | 2020-05-22 | Jefferson | Arkansas | 5069 | 501 | 23 |
169501 | 169501 | 2020-05-23 | Jefferson | Arkansas | 5069 | 504 | 23 |
172542 | 172542 | 2020-05-24 | Jefferson | Arkansas | 5069 | 504 | 23 |
175586 | 175586 | 2020-05-25 | Jefferson | Arkansas | 5069 | 504 | 23 |
178630 | 178630 | 2020-05-26 | Jefferson | Arkansas | 5069 | 510 | 23 |
181674 | 181674 | 2020-05-27 | Jefferson | Arkansas | 5069 | 510 | 23 |
184728 | 184728 | 2020-05-28 | Jefferson | Arkansas | 5069 | 515 | 24 |
187784 | 187784 | 2020-05-29 | Jefferson | Arkansas | 5069 | 516 | 25 |
190849 | 190849 | 2020-05-30 | Jefferson | Arkansas | 5069 | 517 | 25 |
193916 | 193916 | 2020-05-31 | Jefferson | Arkansas | 5069 | 521 | 25 |
196986 | 196986 | 2020-06-01 | Jefferson | Arkansas | 5069 | 523 | 25 |
200059 | 200059 | 2020-06-02 | Jefferson | Arkansas | 5069 | 529 | 25 |
203135 | 203135 | 2020-06-03 | Jefferson | Arkansas | 5069 | 532 | 25 |
206215 | 206215 | 2020-06-04 | Jefferson | Arkansas | 5069 | 536 | 25 |
209296 | 209296 | 2020-06-05 | Jefferson | Arkansas | 5069 | 545 | 25 |
212381 | 212381 | 2020-06-06 | Jefferson | Arkansas | 5069 | 547 | 26 |
215468 | 215468 | 2020-06-07 | Jefferson | Arkansas | 5069 | 548 | 26 |
218559 | 218559 | 2020-06-08 | Jefferson | Arkansas | 5069 | 554 | 26 |
221654 | 221654 | 2020-06-09 | Jefferson | Arkansas | 5069 | 559 | 28 |
224749 | 224749 | 2020-06-10 | Jefferson | Arkansas | 5069 | 573 | 28 |
227851 | 227851 | 2020-06-11 | Jefferson | Arkansas | 5069 | 578 | 28 |
230954 | 230954 | 2020-06-12 | Jefferson | Arkansas | 5069 | 625 | 28 |
234060 | 234060 | 2020-06-13 | Jefferson | Arkansas | 5069 | 628 | 28 |
237167 | 237167 | 2020-06-14 | Jefferson | Arkansas | 5069 | 630 | 28 |
240275 | 240275 | 2020-06-15 | Jefferson | Arkansas | 5069 | 633 | 28 |
243386 | 243386 | 2020-06-16 | Jefferson | Arkansas | 5069 | 633 | 28 |
246499 | 246499 | 2020-06-17 | Jefferson | Arkansas | 5069 | 634 | 28 |
249611 | 249611 | 2020-06-18 | Jefferson | Arkansas | 5069 | 637 | 28 |
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);