names

39 rows where place_id = 598267

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631787 1904747 1904747 defendant Clemson John husbandman 598267 598267 Clemson, John, of Rugge, husbandman 3
3735452 1937325 1937325 defendant Hermer Thomas laborer 598267 598267 Hermer, Thomas, of Rugge, laborer 1
3771055 1948635 1948635 defendant Jonson Robert clerk 598267 598267 Jonson, Robert, of Rugge, clerk 0
3790390 1954812 1954812 defendant Harman Henry husbandman 598267 598267 Harman, Henry, of Rugge, husbandman 0
3790391 1954812 1954812 defendant Colyns John baker 598267 598267 Colyns, John, of Rugge, baker 1
3810171 1961071 1961071 defendant Whytte Richard husbandman 598267 598267 Whytte, Richard, of Rugge, husbandman 0
3913810 1994965 1994965 defendant Rugge John husbandman 598267 598267 Rugge, John, of Rugge, husbandman 0
3913812 1994966 1994966 defendant Rugge John husbandman 598267 598267 Rugge, John, of Rugge, husbandman 0
4529384 2209478 2209478 defendant Prat Richard   598267 598267 Prat, Richard, of Rugge 1
4591874 2228812 2228812 defendant Childe Richard   598267 598267 Childe, Richard, of Rugge 2
4722788 2272441 2272441 defendant Irmonger John husbandman 598267 598267 Irmonger, John, of Rugge, husbandman 7
4726959 2273699 2273699 defendant Luscombe Thomas husbandman 598267 598267 Luscombe, Thomas, of Rugge, husbandman 0
4860715 2314711 2314711 defendant Edewen alias Michell Robert husbandman 598267 598267 Edewen alias Michell, Robert, of Rugge, husbandman 0
5033309 2366620 2366620 defendant Theyne John husbandman 598267 598267 Theyne, John, of Rugge, husbandman 0
5041743 2369132 2369132 defendant Neman Thomas husbandman 598267 598267 Neman, Thomas, of Rugge, husbandman 3
5105633 2388097 2388097 defendant Sterte John husbandman 598267 598267 Sterte, John, of Rugge, husbandman 2
5141539 2398641 2398641 defendant John Alexander husbandman 598267 598267 John, Alexander, of Rugge, husbandman 0
5141542 2398641 2398641 defendant Sharp John, senior husbandman 598267 598267 with Sharp, John, senior, of Rugge, husbandman 3
5141543 2398641 2398641 defendant Aode John chaplain 598267 598267 Aode, John, of Rugge, chaplain 4
5141544 2398641 2398641 defendant Sharp John, junior husbandman 598267 598267 Sharp, John, junior, of Rugge, husbandman 5
5141546 2398641 2398641 defendant Stanet William husbandman 598267 598267 Stanet, William, of Rugge, husbandman 7
5141550 2398642 2398642 defendant Sharp John, senior husbandman 598267 598267 Sharp, John, senior, of Rugge, husbandman 0
5141551 2398642 2398642 defendant Aode John chaplain 598267 598267 Aode, John, of Rugge, chaplain 1
5141552 2398642 2398642 defendant Sharp John, junior husbandman 598267 598267 Sharp, John, junior, of Rugge, husbandman 2
5141554 2398642 2398642 defendant Stanet William husbandman 598267 598267 Stanet, William, of Rugge, husbandman 4
5161333 2404409 2404409 defendant Abyndon William husbandman 598267 598267 Abyndon, William, of Rugge, husbandman 0
5161334 2404409 2404409 defendant Laure John husbandman 598267 598267 Laure, John, of Rugge, husbandman 1
5161335 2404409 2404409 defendant Skynner John, sen husbandman 598267 598267 Skynner, John, sen, of Rugge, husbandman 2
5162650 2404797 2404797 defendant John Alexander husbandman 598267 598267 John, Alexander, of Rugge, husbandman 0
5192410 2413515 2413515 defendant Perkyn John   598267 598267 Perkyn, John, of Rugge, charcoal maker 2
5248444 2429672 2429672 defendant Abyndon William husbandman 598267 598267 Abyndon, William, of Rugge, husbandman 5
5258379 2432735 2432735 defendant Neweman Thomas husbandman 598267 598267 Neweman, Thomas, of Rugge, husbandman 2
5258407 2432744 2432744 defendant Neweman Thomas husbandman 598267 598267 Neweman, Thomas, of Rugge, husbandman 2
5324160 2452314 2452314 defendant Parkyn John, junior   598267 598267 Parkyn, John, junior, of Rugge, laborer, son of Parkyn, John 0
5336692 2456043 2456043 defendant Brok Thomas   598267 598267 Brok, Thomas, of Rugge, tile maker 3
5498551 2504511 2504511 defendant Wassayll Walter husbandman 598267 598267 Wassayll, Walter, of Rugge, husbandman 0
5502985 2505843 2505843 defendant Wassaill Walter husbandman 598267 598267 Wassaill, Walter, of Rugge, husbandman 2
5564887 2524316 2524316 defendant Shottessore Thomas yeoman 598267 598267 Shottessore, Thomas, of Rugge, yeoman 0
5584228 2530135 2530135 defendant Clemson John husbandman 598267 598267 Clemson, John, of Rugge, husbandman 3

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