names

17 rows where place_id = 599019

✎ 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
3634893 1905714 1905714 defendant Lane Robert husbandman 599019 599019 Lane, Robert, of Stirton, husbandman 0
3634896 1905715 1905715 defendant Stirton Thomas yeoman 599019 599019 Stirton, Thomas, of Stirton, yeoman 0
3948859 2006667 2006667 plaintiff Dighton Edmund esq 599019 599019 Dighton, Edmund, of Stirton, esq 0
4537402 2211966 2211966 defendant Croke John   599019 599019 Croke, John, of Stirton 1
5142995 2399075 2399075 defendant Nithyngale Richard husbandman 599019 599019 Nithyngale, Richard, of Stirton, husbandman 5
5153603 2402205 2402205 defendant Philip John yeoman 599019 599019 Philip, John, of Stirton, yeoman 0
5164389 2405317 2405317 defendant Nithyngale Richard husbandman 599019 599019 Nithyngale, Richard, of Stirton, husbandman 5
5245461 2428828 2428828 plaintiff Ranson William   599019 599019 Ranson, William, of Stirton 0
5245489 2428836 2428836 plaintiff Rauson or Ranson William   599019 599019 Rauson or Ranson, William, of Stirton 0
5259925 2433227 2433227 defendant Phelyp John yeoman 599019 599019 Phelyp, John, of Stirton, yeoman 0
5293351 2443036 2443036 defendant Stirton John husbandman 599019 599019 Stirton, John, of Stirton, husbandman 2
5316939 2450146 2450146 plaintiff Eland John (legal representative) 599019 599019 Eland, John, of Stirton, esq, executors of 0
5341498 2457532 2457532 defendant Swallowe Oliver yeoman 599019 599019 Swallowe, Oliver, of Stirton, yeoman 3
5341499 2457532 2457532 defendant Thorysby John yeoman 599019 599019 Thorysby, John, of Stirton, yeoman 4
5341500 2457532 2457532 defendant Webster William yeoman 599019 599019 Webster, William, of Stirton, yeoman 5
5387744 2471559 2471559 defendant Haryngton William   599019 599019 Haryngton, William, of Stirton, wool packer 2
5428583 2483469 2483469 defendant Haryngton William   599019 599019 Haryngton, William, of Stirton, wool packer 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);