ny_times_us_counties

Table actions
⚠️ 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

6,300 rows where county = "Lawrence" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

  • Lawrence · 6,300 ✖
Link rowid date ▲ county state fips cases deaths
1842645 1842645 2021-10-23 Lawrence Alabama 1079 4321 117
1842755 1842755 2021-10-23 Lawrence Arkansas 5075 3260 56
1843259 1843259 2021-10-23 Lawrence Illinois 17101 3355 42
1843358 1843358 2021-10-23 Lawrence Indiana 18093 7460 174
1843672 1843672 2021-10-23 Lawrence Kentucky 21127 2612 38
1844061 1844061 2021-10-23 Lawrence Mississippi 28077 2129 40
1844161 1844161 2021-10-23 Lawrence Missouri 29109 5177 104
1844712 1844712 2021-10-23 Lawrence Ohio 39087 9759 153
1844908 1844908 2021-10-23 Lawrence Pennsylvania 42073 10632 261
1845109 1845109 2021-10-23 Lawrence South Dakota 46081 4283 59
1845185 1845185 2021-10-23 Lawrence Tennessee 47099 9501 121
1839396 1839396 2021-10-22 Lawrence Alabama 1079 4309 117
1839505 1839505 2021-10-22 Lawrence Arkansas 5075 3256 56
1840009 1840009 2021-10-22 Lawrence Illinois 17101 3355 42
1840108 1840108 2021-10-22 Lawrence Indiana 18093 7460 174
1840422 1840422 2021-10-22 Lawrence Kentucky 21127 2612 38
1840811 1840811 2021-10-22 Lawrence Mississippi 28077 2129 40
1840911 1840911 2021-10-22 Lawrence Missouri 29109 5175 104
1841462 1841462 2021-10-22 Lawrence Ohio 39087 9746 153
1841658 1841658 2021-10-22 Lawrence Pennsylvania 42073 10604 261
1841859 1841859 2021-10-22 Lawrence South Dakota 46081 4283 59
1841935 1841935 2021-10-22 Lawrence Tennessee 47099 9501 121
1836147 1836147 2021-10-21 Lawrence Alabama 1079 4296 117
1836256 1836256 2021-10-21 Lawrence Arkansas 5075 3255 56
1836760 1836760 2021-10-21 Lawrence Illinois 17101 3334 42
1836859 1836859 2021-10-21 Lawrence Indiana 18093 7450 174
1837173 1837173 2021-10-21 Lawrence Kentucky 21127 2599 38
1837562 1837562 2021-10-21 Lawrence Mississippi 28077 2124 40
1837662 1837662 2021-10-21 Lawrence Missouri 29109 5169 104
1838213 1838213 2021-10-21 Lawrence Ohio 39087 9725 153
1838409 1838409 2021-10-21 Lawrence Pennsylvania 42073 10584 261
1838610 1838610 2021-10-21 Lawrence South Dakota 46081 4275 59
1838686 1838686 2021-10-21 Lawrence Tennessee 47099 9496 119
1832898 1832898 2021-10-20 Lawrence Alabama 1079 4286 117
1833007 1833007 2021-10-20 Lawrence Arkansas 5075 3250 56
1833511 1833511 2021-10-20 Lawrence Illinois 17101 3325 42
1833610 1833610 2021-10-20 Lawrence Indiana 18093 7436 174
1833924 1833924 2021-10-20 Lawrence Kentucky 21127 2592 38
1834313 1834313 2021-10-20 Lawrence Mississippi 28077 2124 40
1834413 1834413 2021-10-20 Lawrence Missouri 29109 5168 104
1834964 1834964 2021-10-20 Lawrence Ohio 39087 9709 153
1835160 1835160 2021-10-20 Lawrence Pennsylvania 42073 10535 259
1835361 1835361 2021-10-20 Lawrence South Dakota 46081 4273 58
1835437 1835437 2021-10-20 Lawrence Tennessee 47099 9487 119
1829649 1829649 2021-10-19 Lawrence Alabama 1079 4280 117
1829758 1829758 2021-10-19 Lawrence Arkansas 5075 3241 56
1830262 1830262 2021-10-19 Lawrence Illinois 17101 3312 42
1830361 1830361 2021-10-19 Lawrence Indiana 18093 7417 173
1830675 1830675 2021-10-19 Lawrence Kentucky 21127 2581 38
1831064 1831064 2021-10-19 Lawrence Mississippi 28077 2119 40
1831164 1831164 2021-10-19 Lawrence Missouri 29109 5166 104
1831715 1831715 2021-10-19 Lawrence Ohio 39087 9681 153
1831911 1831911 2021-10-19 Lawrence Pennsylvania 42073 10491 259
1832112 1832112 2021-10-19 Lawrence South Dakota 46081 4255 58
1832188 1832188 2021-10-19 Lawrence Tennessee 47099 9480 117
1826400 1826400 2021-10-18 Lawrence Alabama 1079 4269 117
1826509 1826509 2021-10-18 Lawrence Arkansas 5075 3238 56
1827013 1827013 2021-10-18 Lawrence Illinois 17101 3308 42
1827112 1827112 2021-10-18 Lawrence Indiana 18093 7406 173
1827426 1827426 2021-10-18 Lawrence Kentucky 21127 2563 38
1827815 1827815 2021-10-18 Lawrence Mississippi 28077 2114 40
1827915 1827915 2021-10-18 Lawrence Missouri 29109 5160 104
1828466 1828466 2021-10-18 Lawrence Ohio 39087 9663 137
1828662 1828662 2021-10-18 Lawrence Pennsylvania 42073 10472 258
1828863 1828863 2021-10-18 Lawrence South Dakota 46081 4232 58
1828939 1828939 2021-10-18 Lawrence Tennessee 47099 9460 115
1823151 1823151 2021-10-17 Lawrence Alabama 1079 4266 117
1823260 1823260 2021-10-17 Lawrence Arkansas 5075 3238 56
1823764 1823764 2021-10-17 Lawrence Illinois 17101 3299 41
1823863 1823863 2021-10-17 Lawrence Indiana 18093 7382 171
1824177 1824177 2021-10-17 Lawrence Kentucky 21127 2556 38
1824566 1824566 2021-10-17 Lawrence Mississippi 28077 2111 40
1824666 1824666 2021-10-17 Lawrence Missouri 29109 5156 104
1825217 1825217 2021-10-17 Lawrence Ohio 39087 9647 137
1825413 1825413 2021-10-17 Lawrence Pennsylvania 42073 10444 256
1825614 1825614 2021-10-17 Lawrence South Dakota 46081 4223 56
1825690 1825690 2021-10-17 Lawrence Tennessee 47099 9438 115
1819902 1819902 2021-10-16 Lawrence Alabama 1079 4264 117
1820011 1820011 2021-10-16 Lawrence Arkansas 5075 3233 56
1820515 1820515 2021-10-16 Lawrence Illinois 17101 3299 41
1820614 1820614 2021-10-16 Lawrence Indiana 18093 7382 171
1820928 1820928 2021-10-16 Lawrence Kentucky 21127 2556 38
1821317 1821317 2021-10-16 Lawrence Mississippi 28077 2111 40
1821417 1821417 2021-10-16 Lawrence Missouri 29109 5149 104
1821968 1821968 2021-10-16 Lawrence Ohio 39087 9638 137
1822164 1822164 2021-10-16 Lawrence Pennsylvania 42073 10419 256
1822365 1822365 2021-10-16 Lawrence South Dakota 46081 4223 56
1822441 1822441 2021-10-16 Lawrence Tennessee 47099 9438 115
1816653 1816653 2021-10-15 Lawrence Alabama 1079 4252 117
1816762 1816762 2021-10-15 Lawrence Arkansas 5075 3229 56
1817266 1817266 2021-10-15 Lawrence Illinois 17101 3299 41
1817365 1817365 2021-10-15 Lawrence Indiana 18093 7382 171
1817679 1817679 2021-10-15 Lawrence Kentucky 21127 2556 38
1818068 1818068 2021-10-15 Lawrence Mississippi 28077 2111 40
1818168 1818168 2021-10-15 Lawrence Missouri 29109 5145 104
1818719 1818719 2021-10-15 Lawrence Ohio 39087 9630 137
1818915 1818915 2021-10-15 Lawrence Pennsylvania 42073 10375 256
1819116 1819116 2021-10-15 Lawrence South Dakota 46081 4223 56
1819192 1819192 2021-10-15 Lawrence Tennessee 47099 9438 115
1813405 1813405 2021-10-14 Lawrence Alabama 1079 4247 116

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
);
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);