names

43 rows where place_id = 603706

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617816 1873197 1873197 defendant Andrewe John   603706 603706 Andrewe, John, of Stevenage, wheel wright 2
3655507 1911981 1911981 defendant Strode Thomas yeoman 603706 603706 Strode, Thomas, of Stevenage, yeoman 0
3655510 1911982 1911982 defendant Hogekynson Robert yeoman 603706 603706 Hogekynson, Robert, of Stevenage, yeoman 0
3656443 1912261 1912261 defendant Mathewe Robert yeoman 603706 603706 Mathewe, Robert, of Stevenage, yeoman 0
3665065 1915021 1915021 defendant Barfote Richard carpenter 603706 603706 Barfote, Richard, of Stevenage, carpenter 0
3692593 1923870 1923870 defendant Burwell John butcher 603706 603706 Burwell, John, of Stevenage, butcher 0
3706362 1928279 1928279 defendant Burwell John butcher 603706 603706 Burwell, John, of Stevenage, butcher 2
3718716 1932131 1932131 defendant Norres John gent 603706 603706 Norres, John, of Stevenage, gent 0
3722012 1933147 1933147 defendant Hykman William husbandman 603706 603706 Hykman, William, of Stevenage, husbandman 1
3737780 1938037 1938037 defendant Hykman William husbandman 603706 603706 Hykman, William, of Stevenage, husbandman 1
3749510 1941758 1941758 defendant Burwell John butcher 603706 603706 Burwell, John, of Stevenage, butcher 0
3775430 1950060 1950060 defendant Homberstone Thomas yeoman 603706 603706 Homberstone, Thomas, of Stevenage, yeoman 1
3775431 1950060 1950060 defendant Huckull John fuller 603706 603706 Huckull, John, of Stevenage, fuller 2
3775432 1950060 1950060 defendant Hyde Edmund husbandman 603706 603706 Hyde, Edmund, of Stevenage, husbandman 3
3780963 1951779 1951779 defendant Tuk Thomas haberdasher 603706 603706 Tuk, Thomas, of Stevenage, haberdasher 4
3808408 1960506 1960506 defendant Clysby Stephen husbandman 603706 603706 Clysby, Stephen, of Stevenage, husbandman 0
3816748 1963143 1963143 defendant Dardys Robert husbandman 603706 603706 Dardys, Robert, of Stevenage, husbandman 1
3846489 1972455 1972455 defendant Metcalf George husbandman 603706 603706 Metcalf, George, of Stevenage, husbandman 0
3877692 1982781 1982781 defendant Barfote Nicholas yeoman 603706 603706 Barfote, Nicholas, of Stevenage, yeoman 0
4218246 2101885 2101885 defendant Fletcher Stephen maltman 603706 603706 Fletcher, Stephen, of Stevenage, maltman 0
4237232 2108609 2108609 defendant Gynne Edmund yeoman 603706 603706 Gynne, Edmund, of Stevenage, yeoman 0
4237233 2108609 2108609 defendant Heath William yeoman 603706 603706 Heath, William, of Stevenage, yeoman 1
4401541 2165112 2165112 defendant Fletcher Stephen yeoman 603706 603706 Fletcher, Stephen, of Stevenage, yeoman 0
4401773 2165190 2165190 defendant Farre William cordwainer 603706 603706 Farre, William, of Stevenage, cordwainer 0
4412145 2168656 2168656 defendant Fletcher Stephen maltman 603706 603706 Fletcher, Stephen, of Stevenage, yeoman, maltman 0
4762558 2284270 2284270 defendant Chapman Richard   603706 603706 Chapman, Richard, of Stevenage, malt man 0
4797046 2295240 2295240 defendant Croppere John   603706 603706 Croppere, John, of Stevenage, wood buyer 0
4942119 2339518 2339518 defendant Chaundeler John chandler 603706 603706 Chaundeler, John, of Stevenage, chandler 3
5178616 2409459 2409459 defendant Pyg John clerk 603706 603706 Pyg, John, of Stevenage, clerk 3
5270856 2436573 2436573 defendant Pygge John clerk 603706 603706 Pygge, John, of Stevenage, clerk 0
5270857 2436573 2436573 defendant Mason John husbandman 603706 603706 Mason, John, of Stevenage, husbandman 1
5270859 2436574 2436574 defendant Pygge John clerk 603706 603706 Pygge, John, of Stevenage, clerk 0
5270860 2436574 2436574 defendant Mason John husbandman 603706 603706 Mason, John, of Stevenage, husbandman 1
5277395 2438467 2438467 defendant Howe John husbandman 603706 603706 Howe, John, of Stevenage, husbandman 3
5379792 2469262 2469262 defendant Wheler George butcher 603706 603706 Wheler, George, of Stevenage, butcher 1
5379793 2469262 2469262 defendant Whyte John butcher 603706 603706 Whyte, John, of Stevenage, butcher 2
5393536 2473210 2473210 defendant Wheler George butcher 603706 603706 Wheler, George, of Stevenage, butcher 1
5393537 2473210 2473210 defendant Whyte John butcher 603706 603706 Whyte,John, of Stevenage, butcher 2
5491996 2502513 2502513 defendant Mason John yeoman 603706 603706 Mason, John, of Stevenage, yeoman 3
5491997 2502513 2502513 defendant Broun Thomas draper 603706 603706 Broun, Thomas, of Stevenage, draper 4
5583970 2530060 2530060 defendant Hyde William husbandman 603706 603706 Hyde, William, of Stevenage, husbandman 1
5604736 2536344 2536344 defendant Hidde William husbandman 603706 603706 Hidde, William, of Stevenage, husbandman 1
5604737 2536344 2536344 defendant Hogekyn Robert yeoman 603706 603706 Hogekyn, Robert, of Stevenage, yeoman 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);