names

32 rows where place_id = 595186

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3619301 1873640 1873640 defendant Eire Edmund yeoman 595186 595186 Eire, Edmund, of Assheby de la Zouche, Leics, yeoman 1
3695010 1924649 1924649 defendant Lobbe William gent 595186 595186 Lobbe, William, of Assheby de la Zouche, Leics, gent 1
3780865 1951748 1951748 defendant Skelton William clerk 595186 595186 Skelton, William, of Assheby de la Zouche, Leics, clerk 1
3857126 1975859 1975859 defendant Brokesby Francis gent 595186 595186 Brokesby, Francis, of Assheby de la Zouche, Leics, gent 1
3884296 1985012 1985012 defendant Hastyngys William esq 595186 595186 Hastyngys, William, of Assheby de la Zouche, Leics, esq 0
3962951 2011640 2011640 defendant Howett or Huett John drover 595186 595186 Howett or Huett, John, of Assheby de la Zouche, Leics, drover 0
3978419 2017037 2017037 plaintiff Mendyng Edward cooper 595186 595186 Mendyng, Edward, of Assheby de la Zouche, Leics, cooper 0
4809189 2299050 2299050 defendant Clerk Thomas dyer 595186 595186 Clerk, Thomas, of Assheby de la Zouche, Leics, dyer 1
4911466 2330089 2330089 defendant Stokes Thomas esq 595186 595186 Stokes, Thomas, of Assheby de la zouche, Leics, esq 0
4911510 2330101 2330101 defendant Stokes Thomas, senior gent 595186 595186 Stokes, Thomas, senior, of Assheby de la Zouche, Leics, gent 0
4911513 2330102 2330102 defendant Stokes Thomas, senior gent 595186 595186 Stokes, Thomas, senior, of Assheby de la Zouche, Leics, gent 0
4911570 2330120 2330120 defendant Stokys Thomas gent 595186 595186 Stokys, Thomas, of Assheby de la Zouche, Leics, gent 0
4937111 2337979 2337979 defendant Stoke Thomas, senior gent 595186 595186 Stoke, Thomas, senior, of Assheby de la Zouche, Leics, gent 0
5008082 2359249 2359249 defendant Hunt Robert chapman 595186 595186 Hunt, Robert, of Assheby de la Zouche, Leics, chapman 1
5013454 2360771 2360771 defendant Chapman Richard chapman 595186 595186 Chapman, Richard, of Assheby de la Zouche, Leics, chapman 3
5169498 2406817 2406817 defendant Blythe William chapman 595186 595186 Blythe, William, of Assheby de la Zouche, Leics, chapman 2
5219167 2421331 2421331 defendant Forster John yeoman 595186 595186 Forster, John, of Assheby de la Zouche, Leics, yeoman 0
5219178 2421334 2421334 defendant Forster John yeoman 595186 595186 Forster, John, of Assheby de la Zouche, Leics, yeoman 0
5233810 2425476 2425476 defendant Garton John hosier 595186 595186 Garton, John, of Assheby de la Zouche, Leics, hosier 2
5267239 2435516 2435516 defendant Hartwell John chapman 595186 595186 Hartwell, John, of Assheby de la Zouche, Leics, chapman 2
5267245 2435517 2435517 defendant Hartwell John chapman 595186 595186 Hartwell, John, of Assheby de la Zouche, Leics, chapman 2
5386035 2471078 2471078 defendant Foster Thomas yeoman 595186 595186 Foster, Thomas, of Assheby de la Zouche, Leics, yeoman 2
5411391 2478367 2478367 defendant Foster Thomas yeoman 595186 595186 Foster, Thomas, of Assheby de la Zouche, Leics, yeoman 0
5425622 2482645 2482645 defendant Forster Thomas yeoman 595186 595186 Forster, Thomas, of Assheby de la Zouche, Leics, yeoman 0
5453091 2490807 2490807 defendant Grey Humphrey esq 595186 595186 Grey, Humphrey, of Assheby de la Zouche, Leics, esq 3
5465071 2494459 2494459 defendant Grey Humphrey esq 595186 595186 Grey, Humphrey, of Assheby de la Zouche, Leics, esq 3
5476580 2497989 2497989 defendant Grey Humphrey esq 595186 595186 Grey, Humphrey, of Assheby de la Zouche, Leics, esq 0
5492408 2502644 2502644 defendant Bromeley Thomas yeoman 595186 595186 Bromeley, Thomas, of Assheby de la Zouche, Leics, yeoman 3
5496324 2503804 2503804 plaintiff Hynde William yeoman 595186 595186 Hynde, William, of Assheby de la Zouche, Leics, yeoman 0
5496329 2503806 2503806 plaintiff Hyne William yeoman 595186 595186 Hyne, William, of Assheby de la Zouche, Leics, yeoman 0
5526318 2512809 2512809 defendant Eyre Edmund yeoman 595186 595186 Eyre, Edmund, of Assheby de la Zouche, Leics, yeoman 2
5526322 2512810 2512810 defendant Eyre Edmund yeoman 595186 595186 Eyre, Edmund, of Assheby de la Zouche, Leics, yeoman 2

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