names

19 rows where place_id = 587491

✎ 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
3591561 1864986 1864986 defendant Bensted John husbandman 587491 587491 Bensted, John, of Chipnam, husbandman 0
3609666 1870695 1870695 defendant Punter John tailor 587491 587491 Punter, John, of Chipnam, tailor 0
3618272 1873341 1873341 defendant Style Richard husbandman 587491 587491 Style, Richard, of Chipnam, husbandman 0
3677607 1919036 1919036 defendant Mores Joan widow 587491 587491 Mores, Joan, of Chipnam, widow 0
3677608 1919036 1919036 defendant Mores Joan spinster 587491 587491 Mores, Joan, of Chipnam, spinster 1
3746711 1940885 1940885 defendant Cotys John husbandman 587491 587491 Cotys, John, of Chipnam, husbandman 0
3977033 2016535 2016535 defendant Beryman William chapman 587491 587491 Beryman, William, of Chipnam, chapman 0
4315518 2135537 2135537 defendant Coleman Nathaniel tanner 587491 587491 Coleman, Nathaniel, of Chipnam, tanner 0
4315923 2135680 2135680 defendant Visard Arthur tanner 587491 587491 Visard, Arthur, of Chipnam, tanner 0
4315925 2135681 2135681 defendant Visard Arthur tanner 587491 587491 Visard, Arthur, of Chipnam, tanner 0
4336694 2142561 2142561 defendant Baldon Richard (legal representative) 587491 587491 Baldon, Richard, of Chipnam, mercer, administratrix of 0
4359944 2150721 2150721 defendant Balden Richard (legal representative) 587491 587491 Balden, Richard, of Chipnam, mercer, administratrix of 0
4938289 2338355 2338355 defendant Chaundeler Isbel widow 587491 587491 Chaundeler, Isbel, of Chipnam, widow 0
5083499 2381566 2381566 defendant Hoggys John chapman 587491 587491 Hoggys, John, of Chipnam, chapman 0
5284767 2440562 2440562 defendant Bokyngham Richard clothman 587491 587491 Bokyngham, Richard, of Chipnam, clothman 3
5495044 2503417 2503417 plaintiff Grove or Grene John tanner 587491 587491 Grove or Grene, John, of Chipnam, tanner 0
5523295 2512118 2512118 defendant Punter John tailor 587491 587491 Punter, John, of Chipnam, tailor 0
5596740 2533899 2533899 defendant Maundrell John yeoman 587491 587491 Maundrell, John, of Chipnam, yeoman 0
5596741 2533899 2533899 defendant Lylly William yeoman 587491 587491 Lylly, William, of Chipnam, yeoman 1

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