names

35 rows where place_id = 595541

✎ 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
3620941 1874112 1874112 defendant Hyne John husbandman 595541 595541 Hyne, John, of Ossyngton, husbandman 0
3620942 1874112 1874112 defendant Pylhaver Nicholas husbandman 595541 595541 Pylhaver, Nicholas, of Ossyngton, husbandman 1
3675179 1918269 1918269 defendant Clyfton Thomas weaver 595541 595541 Clyfton, Thomas, of Ossyngton, weaver 1
3727429 1934851 1934851 defendant Haye Robert butcher 595541 595541 Haye, Robert, of Ossyngton, butcher 1
3826414 1966109 1966109 defendant Warren Gregory gent 595541 595541 Warren, Gregory, of Ossyngton, gent 1
4783537 2290867 2290867 defendant Garston Richard yeoman 595541 595541 Garston, Richard, of Ossyngton, yeoman 0
4986201 2352800 2352800 defendant Tomkyn William husbandman 595541 595541 Tomkyn, William, of Ossyngton, husbandman 1
5056341 2373469 2373469 defendant Wenell or Wevell John husbandman or wright 595541 595541 Wenell or Wevell, John, of Ossyngton, husbandman or wright 0
5056344 2373470 2373470 defendant Wevell or Wenell John husbandman or wright 595541 595541 Wevell or Wenell, John, of Ossyngton, husbandman or wright 0
5070277 2377603 2377603 defendant Taillour William yeoman 595541 595541 Taillour, William, of Ossyngton, yeoman 3
5070278 2377603 2377603 defendant Hynce Richard yeoman 595541 595541 Hynce, Richard, of Ossyngton, yeoman 4
5119092 2392021 2392021 defendant Antyn John laborer 595541 595541 Antyn, John, of Ossyngton, laborer 9
5246488 2429134 2429134 defendant Whynell John   595541 595541 Whynell, John, of Ossyngton, wright 9
5246491 2429134 2429134 defendant Antyn John   595541 595541 Antyn, John, of Ossyngton, wright 12
5361270 2463552 2463552 defendant Meryng Thomas gent 595541 595541 Meryng, Thomas, of Ossyngton, gent 0
5361271 2463552 2463552 defendant Meryng Alexander gent 595541 595541 Meryng, Alexander, of Ossyngton, gent 1
5361272 2463552 2463552 defendant Meryng Francis gent 595541 595541 Meryng, Francis, of Ossyngton, gent 2
5377268 2468479 2468479 defendant Cokshoet Christopher husbandman 595541 595541 Cokshoet, Christopher, of Ossyngton, husbandman 0
5449089 2489621 2489621 defendant Hyve or Hyne John husbandman 595541 595541 Hyve or Hyne, John, of Ossyngton, husbandman 0
5449090 2489621 2489621 defendant Pykhaver Nicholas husbandman 595541 595541 Pykhaver, Nicholas, of Ossyngton, husbandman 1
5461276 2493316 2493316 defendant Hyve or Hyne John husbandman 595541 595541 Hyve or Hyne, John, of Ossyngton, husbandman 0
5461277 2493316 2493316 defendant Pykhaver Nicholas husbandman 595541 595541 Pykhaver, Nicholas, of Ossyngton, husbandman 1
5487138 2501052 2501052 defendant Hyve or Hyne John husbandman 595541 595541 Hyve or Hyne, John, of Ossyngton, husbandman 0
5497884 2504309 2504309 defendant Hyne or Hyve John husbandman 595541 595541 Hyne or Hyve, John, of Ossyngton, husbandman 0
5497885 2504309 2504309 defendant Pykhaver Nicholas husbandman 595541 595541 Pykhaver, Nicholas, of Ossyngton, husbandman 1
5513376 2509035 2509035 defendant Cokshote Christopher husbandman 595541 595541 Cokshote, Christopher, of Ossyngton, husbandman 3
5528692 2513490 2513490 defendant Nelson Thomas yeoman 595541 595541 Nelson, Thomas, of Ossyngton, yeoman 0
5598760 2534489 2534489 defendant Hyne or Hyve John husbandman 595541 595541 Hyne or Hyve, John, of Ossyngton, husbandman 1
5600088 2534911 2534911 defendant Thomson Thomas laborer 595541 595541 Thomson, Thomas, of Ossyngton, laborer 0
5600089 2534911 2534911 defendant Newbell Thomas laborer 595541 595541 Newbell, Thomas, of Ossyngton, laborer 1
5600091 2534912 2534912 defendant Thomson Thomas laborer 595541 595541 Thomson, Thomas, of Ossyngton, laborer 0
5600092 2534912 2534912 defendant Newbell Thomas laborer 595541 595541 Newbell, Thomas, of Ossyngton, laborer 1
5600094 2534913 2534913 defendant Thomson Thomas laborer 595541 595541 Thomson, Thomas, of Ossyngton, laborer 0
5600095 2534913 2534913 defendant Newbell Thomas laborer 595541 595541 Newbell, Thomas, of Ossyngton, laborer 1
5605875 2536729 2536729 defendant Hall Thomas yeoman 595541 595541 Hall, Thomas, of Ossyngton, 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);