names

40 rows where place_id = 594869

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617907 1873224 1873224 defendant Godeson William husbandman 594869 594869 Godeson, William, of Wygtofte, husbandman 0
3624758 1875279 1875279 defendant Welkey Richard yeoman 594869 594869 Welkey, Richard, of Wygtofte, yeoman 2
3980350 2017741 2017741 defendant Browne Robert chandler 594869 594869 Browne, Robert, of Wygtofte, chandler 4
4131018 2071408 2071408 defendant Walgate John yeoman 594869 594869 Walgate, John, of Wygtofte, yeoman 0
4176680 2087313 2087313 defendant Walgate John yeoman 594869 594869 Walgate, John, of Wygtofte, yeoman 0
4178165 2087834 2087834 defendant Wallgate John yeoman 594869 594869 Wallgate, John, of Wygtofte, yeoman 0
4178166 2087834 2087834 defendant Wallgate Richard yeoman 594869 594869 Wallgate, Richard, of Wygtofte, yeoman 1
4760618 2283663 2283663 defendant Greyne John husbandman 594869 594869 Greyne, John, of Wygtofte, husbandman 0
4973431 2348998 2348998 plaintiff Magelyn John gent 594869 594869 Magelyn, John, of Wygtofte, gent 1
5028260 2365142 2365142 defendant Aleth Thomas gent 594869 594869 Aleth, Thomas, of Wygtofte, gent 2
5192352 2413499 2413499 defendant Aleche Richard yeoman 594869 594869 Aleche, Richard, of Wygtofte, yeoman 2
5192353 2413499 2413499 defendant Aleche Mary widow 594869 594869 Aleche, Mary, of Wygtofte, widow 3
5192357 2413500 2413500 defendant Aleche Richard yeoman 594869 594869 Aleche, Richard, of Wygtofte, yeoman 2
5192358 2413500 2413500 defendant Aleche Mary widow 594869 594869 Aleche, Mary, of Wygtofte, widow 3
5207715 2417995 2417995 defendant Alche Richard yeoman 594869 594869 Alche, Richard, of Wygtofte, yeoman 2
5207716 2417995 2417995 defendant Aleche Mary widow 594869 594869 Aleche, Mary, of Wygtofte, widow 3
5207725 2417997 2417997 defendant Aleche Richard yeoman 594869 594869 Aleche, Richard, of Wygtofte, yeoman 2
5207726 2417997 2417997 defendant Aliche Mary widow 594869 594869 Aliche, Mary, of Wygtofte, widow 3
5315262 2449619 2449619 defendant Chsham Robert roper 594869 594869 Chsham, Robert, of Wygtofte, roper 0
5410581 2478110 2478110 defendant Brigge William yeoman 594869 594869 Brigge, William, of Wygtofte, yeoman 0
5410582 2478110 2478110 defendant Lanke Henry   594869 594869 Lanke, Henry, of Wygtofte, mason 1
5410583 2478110 2478110 defendant Boston William husbandman 594869 594869 Boston, William, of Wygtofte, husbandman 2
5410591 2478111 2478111 defendant Boston William husbandman 594869 594869 (Boston, William, of Wygtofte, husbandman 1
5412894 2478805 2478805 defendant Knyght Lambert husbandman 594869 594869 Knyght, Lambert, of Wygtofte, husbandman 0
5423522 2481997 2481997 defendant Feld Robert husbandman 594869 594869 Feld, Robert, of Wygtofte, husbandman 0
5424512 2482302 2482302 defendant Brygge William husbandman 594869 594869 Brygge, William, of Wygtofte, husbandman 0
5424514 2482302 2482302 defendant Boston William husbandman 594869 594869 Boston, William, of Wygtofte, husbandman 2
5429728 2483829 2483829 defendant Lowes John husbandman 594869 594869 Lowes, John, of Wygtofte, husbandman 2
5442770 2487750 2487750 defendant Feld Robert husbandman 594869 594869 Feld, Robert, of Wygtofte, husbandman 0
5455522 2491560 2491560 defendant Feld Robert husbandman 594869 594869 Feld, Robert, of Wygtofte, husbandman 0
5459247 2492669 2492669 defendant Lowes John husbandman 594869 594869 Lowes, John, of Wygtofte, husbandman 2
5460038 2492933 2492933 defendant Brygge Thomas (legal representative) 594869 594869 Brygge, Thomas, of Wygtofte, gent, executrix of 1
5460039 2492933 2492933 defendant Brygge Agnes widow 594869 594869 Brygge, Agnes, of Wygtofte, widow 2
5471653 2496470 2496470 defendant Brygge Thomas (legal representative) 594869 594869 Brygge, Thomas, of Wygtofte, gent, executrix of 1
5471654 2496470 2496470 defendant Brygge Agnes widow 594869 594869 Brygge, Agnes, of Wygtofte, widow 2
5476434 2497955 2497955 defendant Magelyn William clerk 594869 594869 Magelyn, William, of Wygtofte, clerk 0
5483948 2500135 2500135 defendant Lowes John husbandman 594869 594869 Lowes, John, of Wygtofte, husbandman 2
5494652 2503287 2503287 defendant Brygge John, junior yeoman 594869 594869 Brygge, John, junior, of Wygtofte, yeoman 0
5495907 2503671 2503671 defendant Brygge John husbandman 594869 594869 Brygge, John, of Wygtofte, husbandman 0
5532589 2514735 2514735 defendant Magelyn William chaplain 594869 594869 Magelyn, William, of Wygtofte, chaplain 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);