names

26 rows where place_id = 601018

✎ 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
3643553 1908414 1908414 defendant Diconson Thomas yeoman 601018 601018 Diconson, Thomas, of Burghbrig, yeoman 0
4113816 2065225 2065225 plaintiff Tankard William (legal representative) 601018 601018 Tankard, William, of Burghbrig, esq, executor of 0
4600550 2231394 2231394 defendant Wombewell Robert   601018 601018 Wombewell, Robert, of Burghbrig 1
4654218 2247201 2247201 defendant Tankherd Margaret widow 601018 601018 Tankherd, Margaret, of Burghbrig, widow 3
4674650 2257679 2257679 defendant Inglys Robert gent 601018 601018 Inglys, Robert, of burghbrig, gent 0
4678432 2258860 2258860 defendant Tankard or Taukard Hugh notter or notier 601018 601018 Tankard or Taukard, Hugh, of Burghbrig, notter or notier 0
4678456 2258869 2258869 defendant Tankard Hugh   601018 601018 Tankard, Hugh, of Burghbrig, notary 0
4727557 2273859 2273859 plaintiff Hewyk John glover 601018 601018 Hewyk, John, of Burghbrig, glover 0
4743939 2278756 2278756 defendant Fery John esq 601018 601018 Fery, John, of Burghbrig, esq 0
4793113 2293940 2293940 defendant de Wynslawe William yeoman 601018 601018 de Wynslawe, William, of Burghbrig, yeoman 0
4793128 2293944 2293944 defendant Blawefront William yeoman 601018 601018 Blawefront, William, of Burghbrig, yeoman 1
4857922 2313843 2313843 defendant Flesshewer John shipman 601018 601018 Flesshewer, John, of Burghbrig, shipman 1
4877211 2319830 2319830 defendant Tankerd Hugh gent 601018 601018 Tankerd, Hugh, of Burghbrig, gent 0
4877212 2319830 2319830 defendant Brondester or Broudester thomas draper 601018 601018 Brondester or Broudester, thomas, of Burghbrig, draper 1
4881916 2321242 2321242 defendant Flesshewer John shipman 601018 601018 Flesshewer, John, of Burghbrig, shipman 1
4900497 2326798 2326798 defendant Fery John gent 601018 601018 Fery, John, of Burghbrig, gent 1
4948479 2341503 2341503 defendant Flesshewer John, senior yeoman 601018 601018 Flesshewer, John, senior, of Burghbrig, yeoman 1
4948480 2341503 2341503 defendant Flesshewer John, junior shipman 601018 601018 Flesshewer, John, junior, of Burghbrig, shipman 2
5071444 2377955 2377955 defendant Fery William husbandman 601018 601018 Fery, William, of Burghbrig, husbandman 2
5072752 2378336 2378336 defendant Norton George   601018 601018 Norton, George, of Burghbrig, franklin 0
5074243 2378785 2378785 plaintiff Wetton John   601018 601018 Wetton, John, of Burghbrig 0
5318591 2450654 2450654 defendant Long Robert fletcher 601018 601018 (Long, Robert, of Burghbrig, fletcher 1
5329102 2453785 2453785 plaintiff Aldburgh William (legal representative) 601018 601018 Aldburgh, William, of Burghbrig, gent, executors of 0
5329108 2453785 2453785 defendant Keyham John weaver 601018 601018 Keyham, John, of Burghbrig, weaver 2
5481869 2499510 2499510 defendant Maunby John weaver 601018 601018 Maunby, John, of Burghbrig, weaver 1
5494920 2503378 2503378 defendant Norton William gent 601018 601018 Norton, William, of Burghbrig, gent 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);