names

21 rows where place_id = 587467

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591495 1864967 1864967 defendant Bechecote Richard miller 587467 587467 Bechecote, Richard, of Condover, miller 3
3591496 1864967 1864967 defendant Heynes William yeoman 587467 587467 Heynes, William, of Condover, yeoman 4
3736360 1937615 1937615 defendant Dager John weaver 587467 587467 Dager, John, of Condover, weaver 0
3755225 1943588 1943588 defendant Jukys Roger yeoman 587467 587467 Jukys, Roger, of Condover, yeoman 0
3772835 1949196 1949196 defendant Inkys or Jukys Roger yeoman 587467 587467 Inkys or Jukys, Roger, of Condover, yeoman 0
3873304 1981290 1981290 defendant Coton Nicholas miller 587467 587467 Coton, Nicholas, of Condover, miller 0
3919705 1996928 1996928 defendant Harrys William husbandman 587467 587467 Harrys, William, of Condover, husbandman 0
3919707 1996929 1996929 defendant Hyckys William husbandman 587467 587467 Hyckys, William, of Condover, husbandman 0
4350934 2147582 2147582 defendant Polmer Richard yeoman 587467 587467 Polmer, Richard, of Condover, yeoman 1
5311798 2448556 2448556 defendant Bechecot Ricard husbandman 587467 587467 Bechecot, Ricard, of Condover, husbandman 2
5311799 2448556 2448556 defendant Taylour Julia widow 587467 587467 Taylour, Julia, of Condover, widow 3
5311814 2448560 2448560 defendant Westeley John husbandman 587467 587467 Westeley, John, of Condover, husbandman 0
5329057 2453770 2453770 defendant Westeley John husbandman 587467 587467 Westeley, John, of Condover, husbandman 0
5375760 2468012 2468012 defendant Decon John husbandman 587467 587467 Decon, John, of Condover, husbandman 0
5445206 2488458 2488458 defendant Westeley John husbandman 587467 587467 Westeley, John, of Condover, husbandman 0
5445209 2488459 2488459 defendant Westeley John husbandman 587467 587467 Westeley, John, of Condover, husbandman 1
5457911 2492265 2492265 defendant Westeley John husbandman 587467 587467 Westeley, John, of Condover, husbandman 1
5467609 2495240 2495240 defendant Horwell William weaver 587467 587467 Horwell, William, of Condover, weaver 0
5467610 2495240 2495240 defendant Kayfote Richard laborer 587467 587467 Kayfote, Richard, of Condover, laborer 1
5469705 2495865 2495865 defendant Westeley John husbandman 587467 587467 Westeley, John, of Condover, husbandman 1
5563198 2523834 2523834 defendant Cosenell Robert husbandman 587467 587467 Cosenell, Robert, of Condover, husbandman 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);