names

61 rows where place_id = 597811

✎ 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
3629941 1904221 1904221 defendant Fenne Thomas husbandman 597811 597811 Fenne, Thomas, of Skulton, husbandman 1
3717539 1931775 1931775 plaintiff Downyng Robert   597811 597811 Downyng, Robert, of Skulton 0
3721590 1933056 1933056 defendant Beverley John husbandman 597811 597811 Beverley, John, of Skulton, husbandman 0
3736957 1937805 1937805 defendant Downyng Robert husbandman 597811 597811 Downyng, Robert, of Skulton, husbandman 1
3747216 1941047 1941047 plaintiff Downyng Robert, junior   597811 597811 Downyng, Robert, junior, of Skulton 0
3760877 1945406 1945406 plaintiff Downyng Robert, junior   597811 597811 Downyng, Robert, junior, of Skulton 0
3761711 1945672 1945672 defendant Chambyr Roland husbandman 597811 597811 Chambyr, Roland, of Skulton, husbandman 0
3763992 1946379 1946379 defendant Beverley John husbandman 597811 597811 Beverley, John, of Skulton, husbandman 1
3774025 1949590 1949590 defendant Downyng Robert husbandman 597811 597811 Downyng, Robert, of Skulton, husbandman 0
3791787 1955275 1955275 defendant Downyng Robert husbandman 597811 597811 Downyng, Robert, of Skulton, husbandman 0
3795550 1956489 1956489 defendant Johnson William carpenter 597811 597811 Johnson, William, of Skulton, carpenter 4
3861229 1977229 1977229 defendant Brewster Robert laborer 597811 597811 Brewster, Robert, of Skulton, laborer 2
3882647 1984462 1984462 defendant Gurney Anthony esq 597811 597811 Gurney, Anthony, of Skulton, esq 1
3903504 1991400 1991400 defendant Godfrey Walter alias William husbandman 597811 597811 Godfrey, Walter alias William, of Skulton, husbandman 1
3914388 1995155 1995155 defendant Downyng William husbandman 597811 597811 Downyng, William, of Skulton, husbandman 0
3923064 1998017 1998017 defendant Downyng William husbandman 597811 597811 Downyng, William, of Skulton, husbandman 0
4391418 2161746 2161746 defendant Barnard John tailor 597811 597811 Barnard, John, of Skulton, tailor 2
4577541 2224486 2224486 defendant Cartere Richard   597811 597811 Cartere, Richard, of Skulton 4
4611283 2234593 2234593 defendant Herriessone William miller 597811 597811 Herriessone, William, of Skulton, miller 0
4656480 2247923 2247923 defendant Jacob Henry yeoman 597811 597811 Jacob, Henry, of Skulton, yeoman 3
4657380 2248200 2248200 defendant Jacob Henry woolman 597811 597811 Jacob, Henry, of Skulton, woolman 0
4744858 2279014 2279014 defendant Jacok Henry yeoman 597811 597811 Jacok, Henry, of Skulton, yeoman 0
4744859 2279014 2279014 defendant Bunchewell Robert laborer 597811 597811 Bunchewell, Robert, of Skulton, laborer 1
4764581 2284909 2284909 defendant Brigg John   597811 597811 Brigg, John, of Skulton, shoe maker 1
4877865 2320036 2320036 defendant Chaumber- John gent 597811 597811 Chaumber-, John, of Skulton, gent 1
4974614 2349374 2349374 defendant Jacob Henry yeoman 597811 597811 Jacob, Henry, of Skulton, yeoman 2
5116779 2391339 2391339 defendant Avelyn Stephen husbandman 597811 597811 Avelyn, Stephen, of Skulton, husbandman 1
5116781 2391339 2391339 defendant Baldewyn William husbandman 597811 597811 Baldewyn, William, of Skulton, husbandman 3
5116782 2391339 2391339 defendant Marchaunt John husbandman 597811 597811 Marchaunt, John, of Skulton, husbandman 4
5116783 2391339 2391339 defendant Jacob Henry husbandman 597811 597811 Jacob, Henry, of Skulton, husbandman 5
5124469 2393618 2393618 defendant Avelyn Wiliam gent 597811 597811 Avelyn, Wiliam, of Skulton, gent 0
5126452 2394212 2394212 defendant Selot Robert   597811 597811 Selot, Robert, of Skulton, parson 0
5128882 2394933 2394933 defendant Sellyng Robert   597811 597811 Sellyng, Robert, of Skulton, parson 0
5145136 2399719 2399719 defendant Selot Robert clerk & parson 597811 597811 Selot, Robert, of Skulton, clerk & parson 0
5155894 2402886 2402886 defendant Avelyn William gent 597811 597811 Avelyn, William, of Skulton, gent 0
5172308 2407627 2407627 defendant Avelyn William gent 597811 597811 Avelyn, William, of Skulton, gent 0
5221331 2421938 2421938 defendant Howegate William yeoman 597811 597811 Howegate, William, of Skulton, yeoman 0
5230671 2424583 2424583 plaintiff Howegate William   597811 597811 Howegate, William, of Skulton 1
5234237 2425601 2425601 defendant Conyers Robert   597811 597811 Conyers, Robert, of Skulton, knight 0
5246956 2429275 2429275 defendant Fyssh John husbandman 597811 597811 Fyssh, John, of Skulton, husbandman 1
5251391 2430533 2430533 defendant Avelyn William husbandman 597811 597811 Avelyn, William, of Skulton, husbandman 3
5252613 2430933 2430933 plaintiff Howegate William   597811 597811 Howegate, William, of Skulton 1
5261211 2433620 2433620 defendant Hunte Geoffrey husbandman 597811 597811 Hunte, Geoffrey, of Skulton, husbandman 0
5261215 2433621 2433621 defendant Hogate William husbandman 597811 597811 Hogate, William, of Skulton, husbandman 0
5272753 2437108 2437108 defendant Hoogate William husbandman 597811 597811 Hoogate, William, of Skulton, husbandman 0
5277674 2438554 2438554 defendant Hunte Geoffrey yeoman 597811 597811 Hunte, Geoffrey, of Skulton, yeoman 0
5281916 2439787 2439787 defendant Selot Richard yeoman 597811 597811 Selot, Richard, of Skulton, yeoman 4
5288037 2441516 2441516 defendant Hoogate William husbandman 597811 597811 Hoogate, William, of Skulton, husbandman 0
5288039 2441517 2441517 defendant Hoogate William husbandman 597811 597811 Hoogate, William, of Skulton, husbandman 0
5288578 2441679 2441679 defendant Selot Robert clerk 597811 597811 Selot, Robert, of Skulton, clerk 1
5332076 2454670 2454670 defendant Houghgate Edmund   597811 597811 Houghgate, Edmund, of Skulton, collar maker 0
5332135 2454688 2454688 defendant Welles William husbandman 597811 597811 Welles, William, of Skulton, husbandman 1
5395883 2473910 2473910 plaintiff Barry James clerk 597811 597811 Barry, James, of Skulton, clerk 1
5409151 2477707 2477707 plaintiff Barry James clerk 597811 597811 Barry, James, of Skulton, clerk 1
5422609 2481715 2481715 plaintiff Barry James clerk 597811 597811 Barry, James, of Skulton, clerk 1
5466794 2495018 2495018 plaintiff Barry James clerk 597811 597811 Barry, James, of Skulton, clerk 1
5478102 2498478 2498478 plaintiff Barry James clerk 597811 597811 Barry, James, of Skulton, clerk 1
5478106 2498479 2498479 plaintiff Barry James clerk 597811 597811 Barry, James, of Skulton, clerk 1
5478110 2498480 2498480 plaintiff Barry James clerk 597811 597811 Barry, James, of Skulton, clerk 1
5509563 2507827 2507827 plaintiff Fytte Richard   597811 597811 Fytte, Richard, of Skulton 0
5597960 2534264 2534264 defendant Mallery William chaplain 597811 597811 Mallery, William, of Skulton, 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);