names

26 rows where place_id = 615419

✎ 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
3708800 1929046 1929046 defendant Wydoson Richard husbandman 615419 615419 Wydoson, Richard, of Granby, husbandman 0
4570468 2222337 2222337 defendant Aleyn John   615419 615419 Aleyn, John, of Granby 3
4643131 2244099 2244099 defendant Grene Thomas   615419 615419 Grene, Thomas, of Granby 3
4646926 2245165 2245165 defendant Boteler Robert   615419 615419 Boteler, Robert, of Granby 0
4719830 2271548 2271548 plaintiff Boteler Robert   615419 615419 Boteler, Robert, of Granby 0
4905335 2328261 2328261 defendant Dey John husbandman 615419 615419 Dey, John, of Granby, husbandman 1
4924299 2334034 2334034 defendant Thurkyll Richard yeoman 615419 615419 Thurkyll, Richard, of Granby, yeoman 3
5231772 2424867 2424867 defendant Rachedale William yeoman 615419 615419 Rachedale, William, of Granby, yeoman 1
5264730 2434728 2434728 defendant Beyne Richard husbandman 615419 615419 Beyne, Richard, of Granby, husbandman 0
5264731 2434728 2434728 defendant Routhorn or Ronthorn Andrew husbandman 615419 615419 Routhorn or Ronthorn, Andrew, of Granby, husbandman 1
5264732 2434728 2434728 defendant Hose John husbandman 615419 615419 Hose, John, of Granby, husbandman 2
5264735 2434729 2434729 defendant Beyne Richard husbandman 615419 615419 Beyne, Richard, of Granby, husbandman 0
5264736 2434729 2434729 defendant Routhorn or Ronthorn Andrew husbandman 615419 615419 Routhorn or Ronthorn, Andrew, of Granby, husbandman 1
5264737 2434729 2434729 defendant Hose John husbandman 615419 615419 Hose, John, of Granby, husbandman 2
5296015 2443824 2443824 defendant Leke Thomas gent 615419 615419 Leke, Thomas, of Granby, gent 0
5307408 2447223 2447223 defendant Allerton William yeoman 615419 615419 Allerton, William, of Granby, yeoman 1
5327926 2453421 2453421 defendant Leek Thomas gent 615419 615419 Leek, Thomas, of Granby, gent 1
5339146 2456821 2456821 defendant Leek Thomas gent 615419 615419 Leek, Thomas, of Granby, gent 0
5351681 2460625 2460625 defendant Leeke Thomas gent 615419 615419 Leeke, Thomas, of Granby, gent 2
5366816 2465277 2465277 plaintiff Leek Thomas   615419 615419 Leek, Thomas, of Granby 2
5420000 2480899 2480899 defendant Parnon Thomas husbandman 615419 615419 Parnon, Thomas, of Granby, husbandman 0
5438593 2486480 2486480 defendant Parnon Thomas husbandman 615419 615419 Parnon, Thomas, of Granby, husbandman 0
5438595 2486481 2486481 defendant Pernon Thomas husbandman 615419 615419 Pernon, Thomas, of Granby, husbandman 0
5483580 2500039 2500039 plaintiff Leek Thomas   615419 615419 Leek, Thomas, of Granby 0
5496994 2504038 2504038 plaintiff Leek Thomas   615419 615419 Leek, Thomas, of Granby 0
5511839 2508561 2508561 plaintiff Leek Thomas   615419 615419 Leek, Thomas, of Granby 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);