names

45 rows where place_id = 594111

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3614621 1872222 1872222 defendant Bocher John butcher 594111 594111 Bocher, John, of Acton, Middx, butcher 1
3695872 1924944 1924944 defendant Vaysey Thomas innholder 594111 594111 Vaysey, Thomas, of Acton, Middx, innholder 1
3712065 1930093 1930093 defendant Cawardine William husbandman 594111 594111 Cawardine, William, of Acton, Middx, husbandman 1
3712069 1930094 1930094 defendant Cawardyne William husbandman 594111 594111 Cawardyne, William, of Acton, Middx, husbandman 1
3759284 1944893 1944893 defendant Stutesbery John yeoman 594111 594111 Stutesbery, John, of Acton, Middx, yeoman 0
3842722 1971256 1971256 defendant Brombyll Roger gent 594111 594111 Brombyll, Roger, of Acton, Middx, gent 0
3947082 2006044 2006044 defendant Garraway John   594111 594111 Garraway, John, of Acton, Middx, mechant of the staple, the younger 3
3953498 2008294 2008294 defendant Gurley John yeoman 594111 594111 Gurley, John, of Acton, Middx, yeoman 4
3994231 2022689 2022689 defendant Russell John gent 594111 594111 Russell, John, of Acton, Middx, gent 0
3996319 2023434 2023434 defendant Russell John gent 594111 594111 Russell, John, of Acton, Middx, gent 0
3997214 2023774 2023774 defendant Shepperd Thomas innholder 594111 594111 Shepperd, Thomas, of Acton, Middx, innholder 0
4014906 2030045 2030045 defendant Harlicke Margaret widow 594111 594111 Harlicke, Margaret, of Acton, Middx, widow 1
4014911 2030046 2030046 defendant Garlicke Margaret widow 594111 594111 Garlicke, Margaret, of Acton, Middx, widow 1
4046068 2041032 2041032 defendant Shepard Thomas innholder 594111 594111 Shepard, Thomas, of Acton, Middx, innholder 0
4046070 2041033 2041033 defendant Shepard Thomas innholder 594111 594111 Shepard, Thomas, of Acton, Middx, innholder 0
4074171 2051060 2051060 defendant Cannon Richard yeoman 594111 594111 Cannon, Richard, of Acton, Middx, yeoman 0
4106527 2062624 2062624 defendant Shepeherd Thomas yeoman 594111 594111 Shepeherd, Thomas, of Acton, Middx, yeoman 0
4106530 2062625 2062625 defendant Shepheard Thomas yeoman 594111 594111 Shepheard, Thomas, of Acton, Middx, yeoman 0
4106531 2062625 2062625 defendant Caiman Robert yeoman 594111 594111 Caiman, Robert, of Acton, Middx, yeoman 1
4123242 2068615 2068615 defendant Sheppard Thomas husbandman 594111 594111 Sheppard, Thomas, of Acton, Middx, husbandman 0
4184897 2090225 2090225 defendant Leverett Edmund gent 594111 594111 Leverett, Edmund, of Acton, Middx, gent 2
4207257 2098087 2098087 defendant Shepperd Thomas yeoman 594111 594111 Shepperd, Thomas, of Acton, Middx, yeoman 0
4259465 2116141 2116141 defendant Sheppard Thomas yeoman 594111 594111 Sheppard, Thomas, of Acton, Middx, yeoman 0
4259467 2116142 2116142 defendant Shepparde Thomas yeoman 594111 594111 Shepparde, Thomas, of Acton, Middx, yeoman 0
4278879 2122548 2122548 defendant Gates John yeoman 594111 594111 Gates, John, of Acton, Middx, yeoman 0
4283221 2124034 2124034 defendant Sheppard Thomas gent 594111 594111 Sheppard, Thomas, of Acton, Middx, gent 0
4304714 2131783 2131783 defendant Sheppard Thomas yeoman 594111 594111 Sheppard, Thomas, of Acton, Middx, yeoman 0
4356862 2149633 2149633 defendant Shepperd William yeoman 594111 594111 Shepperd, William, of Acton, Middx, yeoman 0
4356867 2149635 2149635 defendant Shepperd Thomas yeoman 594111 594111 Shepperd, Thomas, of Acton, Middx, yeoman 0
4391743 2161860 2161860 defendant Lok or Look Henry gent 594111 594111 Lok or Look, Henry, of Acton, Middx, gent 0
4394554 2162769 2162769 defendant Hedger Thomas yeoman 594111 594111 Hedger, Thomas, of Acton, Middx, yeoman 1
4594364 2229494 2229494 defendant Fyghter John   594111 594111 Fyghter, John, of Acton, Middx 1
4699097 2265184 2265184 defendant Palmer Thomas stringer 594111 594111 Palmer, Thomas, of Acton, Middx, stringer 1
4750138 2280513 2280513 defendant Jordemayn Robert husbandman 594111 594111 Jordemayn, Robert, of Acton, Middx, husbandman 0
4785114 2291357 2291357 defendant Ardern John tailor 594111 594111 Ardern, John, of Acton, Middx, tailor 0
4809974 2299279 2299279 defendant Wryght John   594111 594111 Wryght, John, of Acton, Middx, parson & clerk 0
4847864 2310817 2310817 defendant Damell John maltman 594111 594111 Damell, John, of Acton, Middx, maltman 2
4914812 2331146 2331146 defendant Veyser John husbandman 594111 594111 Veyser, John, of Acton, Middx, husbandman 2
4914816 2331147 2331147 defendant Veyser John husbandman & son of Thomas Veyser 594111 594111 Veyser, John, of Acton, Middx, husbandman & son of Thomas Veyser 2
4973881 2349148 2349148 defendant Person Richard husbandman 594111 594111 Person, Richard, of Acton, Middx, husbandman 1
4988839 2353613 2353613 plaintiff Broker Richard yeoman 594111 594111 Broker, Richard, of Acton, Middx, yeoman 0
5112415 2390016 2390016 defendant Goolde Richard tanner 594111 594111 Goolde, Richard, of Acton, Middx, tanner 1
5128581 2394838 2394838 defendant Veyse John, senior husbandman 594111 594111 Veyse, John, senior, of Acton, Middx, husbandman 0
5128583 2394839 2394839 defendant Veyser John, senior husbandman 594111 594111 Veyser, John, senior, of Acton, Middx, husbandman 0
5513717 2509142 2509142 defendant Frende Robert yeoman 594111 594111 Frende, Robert, of Acton, Middx, yeoman 4

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