names

25 rows where place_id = 620453

✎ 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
3650653 1910569 1910569 defendant Mylys Robert   620453 620453 Mylys, Robert, of Coksale, apothecary 0
3718877 1932183 1932183 plaintiff Goldewyre Robert (legal representative) 620453 620453 Goldewyre, Robert, of Coksale, clothier, executors of 0
3735739 1937416 1937416 defendant Jaxson John husbandman 620453 620453 Jaxson, John, of Coksale, husbandman 0
3839175 1970176 1970176 defendant Trewe John butcher 620453 620453 Trewe, John, of Coksale, butcher 1
3892147 1987628 1987628 defendant Day John husbandman 620453 620453 Day, John, of Coksale, husbandman 0
4963921 2346120 2346120 plaintiff Chapman John   620453 620453 Chapman, John, of Coksale 0
5034987 2367092 2367092 defendant Vyncent Thomas fuller 620453 620453 Vyncent, Thomas, of Coksale, fuller 0
5131844 2395799 2395799 defendant Burre Thomas butcher 620453 620453 Burre, Thomas, of Coksale, butcher 2
5151368 2401550 2401550 defendant Burre Thomas butcher 620453 620453 Burre, Thomas, of Coksale, butcher 1
5169543 2406828 2406828 defendant Burre Thomas butcher 620453 620453 Burre, Thomas, of Coksale, butcher 1
5255599 2431870 2431870 plaintiff Copschef John   620453 620453 Copschef, John, of Coksale 0
5255601 2431871 2431871 plaintiff Copschef John   620453 620453 Copschef, John, of Coksale 0
5269898 2436304 2436304 plaintiff Copschef John   620453 620453 Copschef, John, of Coksale 0
5271384 2436725 2436725 defendant Child William (legal representative) 620453 620453 Child, William, of Coksale, executrix of 0
5303375 2446004 2446004 defendant Gen Edward yeoman 620453 620453 Gen, Edward, of Coksale, yeoman 3
5319811 2451017 2451017 defendant Aunsell John smith 620453 620453 Aunsell, John, of Coksale, smith 2
5319813 2451017 2451017 defendant Kebyll or Kevyll John fuller 620453 620453 Kebyll or Kevyll, John, of Coksale, fuller 4
5332420 2454761 2454761 defendant Auncell John smith 620453 620453 Auncell, John, of Coksale, smith 2
5332421 2454761 2454761 defendant Smyth John barber 620453 620453 Smyth, John, of Coksale, barber 3
5350117 2460160 2460160 plaintiff Clyot Robert fuller 620453 620453 Clyot, Robert, of Coksale, fuller 0
5381594 2469789 2469789 defendant Borle John smith 620453 620453 Borle, John, of Coksale, smith 2
5414828 2479369 2479369 defendant Borle John smith 620453 620453 Borle, John, of Coksale, smith 2
5430726 2484130 2484130 defendant Borle John smith 620453 620453 Borle, John, of Coksale, smith 2
5447700 2489187 2489187 defendant Panell Thomas clothmaker 620453 620453 Panell, Thomas, of Coksale, clothmaker 4
5578384 2528309 2528309 defendant Brode Thomas weaver 620453 620453 Brode, Thomas, of Coksale, weaver 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);