names

62 rows where place_id = 652592

✎ 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
3923729 1998245 1998245 defendant Hardyng John   652592 652592 Hardyng, John, of Skeyton, worsted weaver 0
3924633 1998552 1998552 defendant Bybald Robert husbandman 652592 652592 Bybald, Robert, of Skeyton, husbandman 0
4210512 2099231 2099231 defendant Gowghe William   652592 652592 Gowghe, William, of Skeyton, surgeon 3
4247739 2112226 2112226 defendant Sterne Thomas gent 652592 652592 Sterne, Thomas, of Skeyton, gent 0
4257606 2115518 2115518 defendant Carrington Richard clerk 652592 652592 Carrington, Richard, of Skeyton, clerk 0
4276289 2121651 2121651 defendant Sterne Thomas gent 652592 652592 Sterne, Thomas, of Skeyton, gent 2
4464976 2189711 2189711 defendant Couper Roger   652592 652592 Couper, Roger, of Skeyton 3
4505074 2202118 2202118 defendant Turpyn Thomas   652592 652592 Turpyn, Thomas, of Skeyton 0
4530805 2209925 2209925 defendant Herre Roger   652592 652592 Herre, Roger, of Skeyton 1
4530807 2209925 2209925 defendant Felde John   652592 652592 Felde, John, of Skeyton 3
4530808 2209925 2209925 defendant Holt John   652592 652592 Holt, John, of Skeyton 4
4560860 2219353 2219353 defendant Coupere John   652592 652592 Coupere, John, of Skeyton 5
4560888 2219358 2219358 defendant Coupere John   652592 652592 Coupere, John, of Skeyton 2
4630702 2240501 2240501 defendant Gunnes Richard   652592 652592 Gunnes, Richard, of Skeyton 9
4637853 2242609 2242609 defendant Molys John   652592 652592 Molys, John, of Skeyton 3
4638524 2242807 2242807 defendant Gateman John   652592 652592 Gateman, John, of Skeyton 2
4648362 2245571 2245571 defendant Gunnes Richard   652592 652592 Gunnes, Richard, of Skeyton 1
4680842 2259629 2259629 defendant Turpyn John butcher 652592 652592 Turpyn, John, of Skeyton, butcher 6
4697365 2264661 2264661 defendant Turpyn Thomas yeoman 652592 652592 Turpyn, Thomas, of Skeyton, yeoman 1
4703663 2266524 2266524 defendant Geldeston John miller 652592 652592 Geldeston, John, of Skeyton, miller 0
4706542 2267424 2267424 defendant Turpyn Thomas yeoman 652592 652592 Turpyn, Thomas, of Skeyton, yeoman 4
4706543 2267424 2267424 defendant Here Roger yeoman 652592 652592 Here, Roger, of Skeyton, yeoman 5
4720692 2271805 2271805 defendant Baxster Clement baker 652592 652592 Baxster, Clement, of Skeyton, baker 3
4724685 2273018 2273018 defendant Heere Roger husbandman 652592 652592 Heere, Roger, of Skeyton, husbandman 0
4724688 2273019 2273019 defendant Heere Roger husbandman 652592 652592 Heere, Roger, of Skeyton, husbandman 0
4724692 2273020 2273020 defendant Heere Roger husbandman 652592 652592 Heere, Roger, of Skeyton, husbandman 0
4735938 2276390 2276390 defendant Tunnes Richard yeoman 652592 652592 Tunnes, Richard, of Skeyton, yeoman 1
4748195 2279981 2279981 defendant Turpyn Thomas yeoman 652592 652592 Turpyn, Thomas, of Skeyton, yeoman 3
4791461 2293423 2293423 defendant Turpyng Thomas yeoman 652592 652592 Turpyng, Thomas, of Skeyton, yeoman 6
4814379 2300606 2300606 defendant Love or Lone Thomas husbandman 652592 652592 Love or Lone, Thomas, of Skeyton, husbandman 0
4963697 2346053 2346053 defendant Fuller Roger husbandman 652592 652592 Fuller, Roger, of Skeyton, husbandman 2
4996105 2355693 2355693 plaintiff Grondesburgh John   652592 652592 Grondesburgh, John, of Skeyton, parson 0
5022005 2363328 2363328 defendant Holme Oliver husbandman 652592 652592 Holme, Oliver, of Skeyton, husbandman 0
5028191 2365116 2365116 defendant Dybold Henry husbandman 652592 652592 Dybold, Henry, of Skeyton, husbandman 0
5028192 2365116 2365116 defendant Howes Adam husbandman 652592 652592 Howes, Adam, of Skeyton, husbandman 1
5028193 2365116 2365116 defendant Lelye Ralph carpenter 652592 652592 Lelye, Ralph, of Skeyton, carpenter 2
5028194 2365116 2365116 defendant Galt William husbandman 652592 652592 Galt, William, of Skeyton, husbandman 3
5062950 2375449 2375449 defendant Maryet Clement yeoman 652592 652592 Maryet, Clement, of Skeyton, yeoman 0
5071962 2378103 2378103 defendant Dybald Henry husbandman 652592 652592 Dybald, Henry, of Skeyton, husbandman 2
5100590 2386601 2386601 defendant Galt Roger yeoman 652592 652592 Galt, Roger, of Skeyton, yeoman 0
5100591 2386601 2386601 defendant Galt Robert yeoman 652592 652592 Galt, Robert, of Skeyton, yeoman 1
5134880 2396705 2396705 defendant Galte William yeoman 652592 652592 Galte, William, of Skeyton, yeoman 0
5170582 2407116 2407116 defendant Maryot Clement yeoman 652592 652592 Maryot, Clement, of Skeyton, yeoman 0
5170583 2407116 2407116 defendant Galt Roger laborer 652592 652592 Galt, Roger, of Skeyton, laborer 1
5255053 2431697 2431697 defendant Galt Robert laborer 652592 652592 Galt, Robert, of Skeyton, laborer 0
5270628 2436506 2436506 defendant Odes John thatcher 652592 652592 Odes, John, of Skeyton, thatcher 4
5270629 2436506 2436506 defendant Lylly William carpenter 652592 652592 Lylly, William, of Skeyton, carpenter 5
5273110 2437207 2437207 defendant Cheteryng William   652592 652592 Cheteryng, William, of Skeyton, parson 1
5288752 2441725 2441725 defendant Cheteryng Edmund husbandman 652592 652592 Cheteryng, Edmund, of Skeyton, husbandman 1
5323506 2452111 2452111 defendant Cheteryng Geoffrey clerk 652592 652592 Cheteryng, Geoffrey, of Skeyton, clerk 0
5323507 2452111 2452111 defendant Cheteryng Edmund husbandman 652592 652592 Cheteryng, Edmund, of Skeyton, husbandman 1
5323508 2452111 2452111 defendant Edmondys William laborer 652592 652592 Edmondys, William, of Skeyton, laborer 2
5332314 2454730 2454730 defendant Chitteryng Edmund yeoman 652592 652592 Chitteryng, Edmund, of Skeyton, yeoman 0
5354934 2461615 2461615 defendant Cheteryng Geoffrey clerk 652592 652592 Cheteryng, Geoffrey, of Skeyton, clerk 5
5365888 2464984 2464984 defendant Lely John, senior husbandman 652592 652592 Lely, John, senior, of Skeyton, husbandman 2
5381106 2469652 2469652 defendant Monelyte Richard   652592 652592 Monelyte, Richard, of Skeyton, worsted weaver 1
5396822 2474174 2474174 defendant Galt Roger husbandman 652592 652592 Galt, Roger, of Skeyton, husbandman 0
5413944 2479101 2479101 defendant Cheteryng Edmund   652592 652592 Cheteryng, Edmund, of Skeyton 0
5423702 2482053 2482053 defendant Galt Roger husbandman 652592 652592 Galt, Roger, of Skeyton, husbandman 0
5500603 2505117 2505117 defendant Bysshop John husbandman 652592 652592 Bysshop, John, of Skeyton, husbandman 2
5505613 2506674 2506674 defendant Cheteryng Geoffrey clerk 652592 652592 Cheteryng, Geoffrey, of Skeyton, clerk 3
5627422 2552546 2552546 defendant Heet Roger husbandman 652592 652592 Heet, Roger, of Skeyton, husbandman 5

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