names

23 rows where place_id = 786319

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4696867 2264499 2264499 defendant Dilley John husbandman 786319 786319 Dilley, John, of Reynham, Kent, husbandman 1
4696872 2264501 2264501 defendant Dylkey John husbandman 786319 786319 Dylkey, John, of Reynham, Kent, husbandman 1
4700329 2265519 2265519 defendant Hay John de la husbandman 786319 786319 Hay, John de la, of Reynham, Kent, husbandman 0
4905960 2328465 2328465 defendant Parker William tailor 786319 786319 Parker, William, of Reynham, Kent, tailor 4
5050296 2371712 2371712 defendant Renns Thomas gent 786319 786319 Renns, Thomas, of Reynham, Kent, gent 0
5050300 2371713 2371713 defendant Renns Thomas gent 786319 786319 Renns, Thomas, of Reynham, Kent, gent 0
5108429 2388900 2388900 defendant Cosyngton Richard gent 786319 786319 Cosyngton, Richard, of Reynham, Kent, gent 0
5229070 2424113 2424113 defendant Rychyngode John husbandman 786319 786319 Rychyngode, John, of Reynham, Kent, husbandman 0
5231613 2424829 2424829 defendant Rechyngwode John husbandman 786319 786319 Rechyngwode, John, of Reynham,Kent, husbandman 1
5248352 2429651 2429651 defendant Burbage James   786319 786319 Burbage, James, of Reynham, Kent 1
5248355 2429652 2429652 defendant Burbage James yeoman 786319 786319 Burbage, James, of Reynham, Kent, yeoman 1
5282339 2439895 2439895 defendant Remys Thomas (legal representative) 786319 786319 Remys, Thomas, of Reynham, Kent, gent, executrix of 0
5290771 2442303 2442303 defendant Cosyngton Richard gent 786319 786319 Cosyngton, Richard, of Reynham, Kent, gent 0
5290773 2442304 2442304 defendant Cosyngton Richard gent 786319 786319 Cosyngton, Richard, of Reynham, Kent, gent 0
5340387 2457196 2457196 defendant Myre John pardoner 786319 786319 Myre, John, of Reynham, Kent, pardoner 3
5340472 2457220 2457220 defendant Elmeston Henry husbandman 786319 786319 Elmeston, Henry, of Reynham, Kent, husbandman 3
5358966 2462853 2462853 defendant Cornell Richard shipman 786319 786319 Cornell, Richard, of Reynham, Kent, shipman 0
5372025 2466843 2466843 defendant Bettenham Henry gent 786319 786319 Bettenham, Henry, of Reynham, Kent, gent 0
5380645 2469512 2469512 defendant Jorden John shipman 786319 786319 Jorden, John, of Reynham, Kent, shipman 4
5385553 2470937 2470937 defendant Jorden John shipman 786319 786319 Jorden, John, of Reynham, Kent, shipman 4
5469584 2495822 2495822 defendant Betnam Henry gent 786319 786319 Betnam, Henry, of Reynham, Kent, gent 0
5480908 2499243 2499243 defendant Betnam Henry gent 786319 786319 Betnam, Henry, of Reynham, Kent, gent 0
5513439 2509051 2509051 defendant Cosynton Richard gent 786319 786319 Cosynton, Richard, of Reynham, Kent, gent 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);