names

37 rows where place_id = 761517

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4479619 2194289 2194289 defendant Munsterworth Richard   761517 761517 Munsterworth, Richard, of Great Dene 0
4535757 2211462 2211462 defendant James Henry   761517 761517 James, Henry, of Great Dene 1
4586574 2227210 2227210 defendant Roberd William   761517 761517 Roberd, William, of Great Dene 0
4609769 2234150 2234150 defendant Perpoynt John   761517 761517 Perpoynt, John, of Great Dene 0
4617825 2236578 2236578 defendant Ingham Thomas   761517 761517 Ingham, Thomas, of Great Dene 3
4624966 2238776 2238776 defendant Fader Richard   761517 761517 Fader, Richard, of Great Dene 0
4624968 2238776 2238776 defendant Hosteler William   761517 761517 Hosteler, William, of Great Dene 2
4686303 2261321 2261321 defendant Colman John   761517 761517 Colman, John, of Great Dene, milward 1
4686305 2261321 2261321 defendant Sadeler Roger sadler 761517 761517 Sadeler, Roger, of Great Dene, sadler 3
4697062 2264561 2264561 defendant Aubrey William   761517 761517 Aubrey, William, of Great Dene, wire drawer 1
4702026 2266046 2266046 plaintiff Grendore Thomas (legal representative) 761517 761517 Grendore, Thomas, of Great Dene, executors of 0
4702171 2266088 2266088 defendant Greyndour John gent 761517 761517 Greyndour, John, of Great Dene, gent 0
4702181 2266092 2266092 plaintiff Greyndore Thomas (legal representative) 761517 761517 Greyndore, Thomas, of Great Dene, executors of 0
4718570 2271145 2271145 defendant Wodeward Thomas husbandman 761517 761517 Wodeward, Thomas, of Great Dene, husbandman 2
4720528 2271757 2271757 defendant Perpoynt John yeoman 761517 761517 Perpoynt, John, of Great Dene, yeoman 3
4726237 2273492 2273492 plaintiff Greyndove Thomas (legal representative) 761517 761517 Greyndove, Thomas, of Great Dene, executors of 0
4734853 2276057 2276057 defendant Broun William yeoman 761517 761517 Broun, William, of Great Dene, yeoman 2
4749238 2280260 2280260 defendant Greynd Thomas (legal representative) 761517 761517 Greynd, Thomas, of Great Dene, executors of 2
4749244 2280261 2280261 defendant Greyndo Thomas (legal representative) 761517 761517 Greyndo, Thomas, of Great Dene, executors of 2
4772910 2287498 2287498 defendant Combere John smith 761517 761517 Combere, John, of Great Dene, smith 3
4808406 2298806 2298806 defendant Stodelegh William husbandman 761517 761517 Stodelegh, William, of Great Dene, husbandman 0
4827016 2304493 2304493 defendant Bond Thomas laborer 761517 761517 Bond, Thomas, of Great Dene, laborer 0
4830376 2305533 2305533 defendant Dene Henry de gent 761517 761517 Dene, Henry de, of Great Dene, gent 1
4830757 2305648 2305648 plaintiff Lewys Thomas   761517 761517 Lewys, Thomas, of Great Dene 1
4830758 2305648 2305648 defendant Frere William   761517 761517 Frere, William, of Great Dene, smith, son & heir of Thomas Frere, of Little Dene 0
4838043 2307821 2307821 defendant Wyther William clerk 761517 761517 Wyther, William, of Great Dene, clerk 0
4838854 2308082 2308082 defendant Garon Richard yeoman 761517 761517 Garon, Richard, of Great Dene, yeoman 0
4913023 2330568 2330568 defendant Dene Henry yeoman 761517 761517 Dene, Henry, of Great Dene, yeoman 0
4915178 2331253 2331253 defendant James Nicholas smith 761517 761517 James, Nicholas, of Great Dene, smith 0
5044892 2370107 2370107 defendant Lewys John fisher 761517 761517 Lewys, John, of Great Dene, fisher 0
5044893 2370107 2370107 defendant Kynge John, junior tailor 761517 761517 Kynge, John, junior, of Great Dene, tailor 1
5178190 2409326 2409326 defendant Benehale John yeoman 761517 761517 Benehale, John, of Great Dene, yeoman 0
5178280 2409349 2409349 defendant Benehale John yeoman 761517 761517 Benehale, John, of Great Dene, yeoman 0
5201331 2416146 2416146 defendant Benehale John yeoman 761517 761517 Benehale, John, of Great Dene, yeoman 0
5369461 2466041 2466041 plaintiff Faukener Damell (legal representative) 761517 761517 Faukener, Damell, of Great Dene, smith holder, executor of 0
5369463 2466041 2466041 defendant Garon John yeoman 761517 761517 Garon, John, of Great Dene, gent, son & heir of Richard Garon, of Great Dene, yeoman 0
5621692 2550692 2550692 plaintiff Taillour Richard   761517 761517 Taillour, Richard, of Great Dene 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);