names

34 rows where place_id = 594143

✎ 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
3614729 1872254 1872254 defendant Norton William weaver 594143 594143 Norton, William, of Waltham Cross, weaver 3
3881845 1984181 1984181 defendant Wygyns Thomas innholder 594143 594143 Wygyns, Thomas, of Waltham Cross, innholder 0
4591200 2228604 2228604 defendant Sheryng Isabel   594143 594143 Sheryng, Isabel, of Waltham Cross 3
4662163 2249640 2249640 defendant Wheleman John ostler 594143 594143 Wheleman, John, of Waltham Cross, ostler 0
4693531 2263478 2263478 plaintiff Baude or Bande Thomas esq 594143 594143 Baude or Bande, Thomas, of Waltham Cross, esq 0
4693536 2263479 2263479 plaintiff Baude Thomas esq 594143 594143 Baude, Thomas, of Waltham Cross, esq 0
4812954 2300165 2300165 plaintiff Walter Simon   594143 594143 Walter, Simon, of Waltham Cross 1
5035719 2367302 2367302 defendant Trewelove Robert butcher 594143 594143 Trewelove, Robert, of Waltham Cross, butcher 0
5100914 2386678 2386678 defendant Newport William yeoman 594143 594143 Newport, William, of Waltham Cross, yeoman 1
5100917 2386679 2386679 defendant Newport William yeoman 594143 594143 Newport, William, of Waltham Cross, yeoman 1
5430400 2484027 2484027 defendant Cawethorn John yeoman 594143 594143 Cawethorn, John, of Waltham Cross, yeoman 0
5455575 2491576 2491576 defendant Kelsey Robert   594143 594143 Kelsey, Robert, of Waltham Cross 0
5455577 2491576 2491576 defendant Harryson Robert smith 594143 594143 Harryson, Robert, of Waltham Cross, smith 2
5455578 2491576 2491576 defendant Defford Richard tailor 594143 594143 Defford, Richard, of Waltham Cross, tailor 3
5455579 2491576 2491576 defendant Devaunt John yeoman 594143 594143 Devaunt, John, of Waltham Cross, yeoman 4
5455582 2491577 2491577 defendant Cawethorn John yeoman 594143 594143 Cawethorn, John, of Waltham Cross, yeoman 1
5461902 2493503 2493503 defendant Cawethorn John yeoman 594143 594143 Cawethorn, John, of Waltham Cross, yeoman 1
5461903 2493503 2493503 defendant Harryson Robert smith 594143 594143 Harryson, Robert, of Waltham Cross, smith 2
5461907 2493503 2493503 defendant Multon William yeoman 594143 594143 Multon, William, of Waltham Cross, yeoman 6
5467336 2495178 2495178 defendant Cawethorn John yeoman 594143 594143 Cawethorn, John, of Waltham Cross, yeoman 1
5467341 2495179 2495179 defendant Cawethorn John yeoman 594143 594143 Cawethorn, John, of Waltham Cross, yeoman 1
5467342 2495179 2495179 defendant Harrysson Robert smith 594143 594143 Harrysson, Robert, of Waltham Cross, smith 2
5467343 2495179 2495179 defendant Defford Richard tailor 594143 594143 Defford, Richard, of Waltham Cross, tailor 3
5467346 2495179 2495179 defendant Multon William yeoman 594143 594143 Multon, William, of Waltham Cross, yeoman 6
5467349 2495180 2495180 defendant Cawethorn John yeoman 594143 594143 Cawethorn, John, of Waltham Cross, yeoman 1
5467351 2495180 2495180 defendant Defford Richard yeoman 594143 594143 Defford, Richard, of Waltham Cross, tailor Devaunt, John, of Chesthunt, yeoman 3
5467353 2495180 2495180 defendant Multon William yeoman 594143 594143 Multon, William, of Waltham Cross, yeoman 5
5473438 2497019 2497019 defendant Cawethorn John yeoman 594143 594143 Cawethorn, John, of Waltham Cross, yeoman 1
5473439 2497019 2497019 defendant Harrysson Robert smith 594143 594143 Harrysson, Robert, of Waltham Cross, smith 2
5473440 2497019 2497019 defendant Defford Richard tailor 594143 594143 Defford, Richard, of Waltham Cross, tailor 3
5473443 2497019 2497019 defendant Multon William yeoman 594143 594143 Multon, William, of Waltham Cross, yeoman 6
5473446 2497020 2497020 defendant Cawethorn John yeoman 594143 594143 Cawethorn, John, of Waltham Cross, yeoman 1
5473448 2497020 2497020 defendant Defford Richard tailor 594143 594143 Defford, Richard, of Waltham Cross, tailor 3
5473451 2497020 2497020 defendant Multon William yeoman 594143 594143 Multon, William, of Waltham Cross, yeoman 6

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