names

36 rows where place_id = 593545

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612303 1871481 1871481 defendant Moryson Richard yeoman 593545 593545 Moryson, Richard, of Northawe, yeoman 0
3618128 1873294 1873294 defendant Godard John yeoman 593545 593545 Godard, John, of Northawe, yeoman 1
3621188 1874169 1874169 defendant Lowen Nicholas tailor 593545 593545 Lowen, Nicholas, of Northawe, tailor 6
3879205 1983299 1983299 defendant Parkynson Richard laborer 593545 593545 Parkynson, Richard, of Northawe, laborer 0
3879219 1983301 1983301 defendant Foster John, senior laborer 593545 593545 Foster, John, senior, of Northawe, laborer 2
3879220 1983301 1983301 defendant Farmer John smith 593545 593545 Farmer, John, of Northawe, smith 3
3879225 1983302 1983302 defendant Foster John, senior laborer 593545 593545 Foster, John, senior, of Northawe, laborer 1
3879226 1983302 1983302 defendant farmer John smith 593545 593545 farmer, John, of Northawe, smith 2
4415857 2169850 2169850 defendant Forester John le   593545 593545 Forester, John le, of Northawe 0
4415858 2169850 2169850 defendant Forester Nicholas le   593545 593545 Forester, Nicholas le, of Northawe 1
4415860 2169851 2169851 defendant Forester John le   593545 593545 Forester, John le, of Northawe 0
4424613 2172538 2172538 defendant Forester John le   593545 593545 Forester, John le, of Northawe 0
4424614 2172538 2172538 defendant Forester Nicholas le   593545 593545 Forester, Nicholas le, of Northawe 1
4763355 2284527 2284527 defendant Hynde William husbandman 593545 593545 Hynde, William, of Northawe, husbandman 0
4860718 2314711 2314711 defendant Lowyn William husbandman 593545 593545 Lowyn, William, of Northawe, husbandman 3
4937563 2338122 2338122 defendant Lowyn allias Dawedeney William yeoman 593545 593545 Lowyn allias Dawedeney, William, of Northawe, yeoman 0
4997399 2356072 2356072 defendant Dabeney William brewer 593545 593545 Dabeney, William, of Northawe, brewer 0
5027426 2364900 2364900 defendant Daueneye William husbandman 593545 593545 Daueneye, William, of Northawe, husbandman 6
5106302 2388283 2388283 defendant Daveney William brewer 593545 593545 Daveney, William, of Northawe, brewer 1
5132099 2395880 2395880 defendant Deweney Henry laborer 593545 593545 Deweney, Henry, of Northawe, laborer 2
5187787 2412147 2412147 defendant Baseley Roger husbandman alias butcher 593545 593545 Baseley, Roger, of Northawe, husbandman alias butcher 0
5205724 2417417 2417417 defendant Baseley Roger husbandman alias butcher 593545 593545 Baseley, Roger, of Northawe, husbandman alias butcher 0
5239159 2427042 2427042 defendant Baseley Robert laborer 593545 593545 Baseley, Robert, of Northawe, laborer 1
5310601 2448207 2448207 defendant Steven William weaver 593545 593545 Steven, William, of Northawe, weaver 1
5385350 2470885 2470885 defendant Rumford John husbandman 593545 593545 Rumford, John, of Northawe, husbandman 4
5397415 2474345 2474345 defendant Rumford John husbandman 593545 593545 Rumford, John, of Northawe, husbandman 4
5397738 2474424 2474424 defendant Mery John yeoman 593545 593545 Mery, John, of Northawe, yeoman 1
5402367 2475751 2475751 defendant Langley Robert husbandman 593545 593545 Langley, Robert, of Northawe, husbandman 1
5405539 2476662 2476662 defendant Lowyn Thomas husbandman 593545 593545 Lowyn, Thomas, of Northawe, husbandman 0
5421520 2481368 2481368 defendant Mery Philip yeoman 593545 593545 Mery, Philip, of Northawe, yeoman 1
5425044 2482454 2482454 defendant Mery Philip yeoman 593545 593545 Mery, Philip, of Northawe, yeoman 2
5425049 2482456 2482456 defendant Mery Philip yeoman 593545 593545 Mery, Philip, of Northawe, yeoman 1
5425054 2482457 2482457 defendant Mery Philip yeoman 593545 593545 Mery, Philip, of Northawe, yeoman 1
5488159 2501353 2501353 defendant Lowyn Thomas husbandman 593545 593545 Lowyn, Thomas, of Northawe, husbandman 0
5553725 2521124 2521124 defendant Mayo Thomas husbandman 593545 593545 Mayo, Thomas, of Northawe, husbandman 4
5565401 2524472 2524472 defendant Blok John, junior collier 593545 593545 Blok, John, junior, of Northawe, collier 0

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