names

30 rows where place_id = 623693

✎ 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
3753818 1943137 1943137 defendant Awner Henry fisher 623693 623693 Awner, Henry, of Stepney, fisher 1
3753819 1943137 1943137 defendant Geoffrey John fisher 623693 623693 Geoffrey, John, of Stepney, fisher 2
3891993 1987572 1987572 defendant Nancarowe William mariner 623693 623693 Nancarowe, William, of Stepney, mariner 0
3997402 2023816 2023816 defendant Pelson John yeoman 623693 623693 Pelson, John, of Stepney, yeoman 0
4062147 2046749 2046749 defendant James William gent 623693 623693 James, William, of Stepney, gent 0
4342415 2144620 2144620 defendant Kynge Abraham yeoman 623693 623693 Kynge, Abraham, of Stepney, or of Baddowe Magna, yeoman 0
4344034 2145191 2145191 defendant Adams Margaret widow 623693 623693 Adams, Margaret, of Stepney, widow 1
4402495 2165419 2165419 defendant Robynson Edward innholder 623693 623693 Robynson, Edward, of Stepney, innholder 0
4706387 2267379 2267379 defendant Maunefeld Roger husbandman 623693 623693 Maunefeld, Roger, of Stepney, husbandman 2
4768067 2285980 2285980 defendant Maundefeld Rogert tailor 623693 623693 Maundefeld, Rogert, of Stepney, tailor 0
4772327 2287309 2287309 defendant Payn Richard husbandman 623693 623693 Payn, Richard, of Stepney, husbandman 0
4830712 2305632 2305632 defendant Wodward Thomas shipman 623693 623693 Wodward, Thomas, of Stepney, shipman 0
4847838 2310812 2310812 defendant Conwey John husbandman 623693 623693 Conwey, John, of Stepney, husbandman 0
4928489 2335335 2335335 defendant Lanwell Thomas brewer 623693 623693 Lanwell, Thomas, of Stepney, brewer 0
4987484 2353212 2353212 defendant Fraunceys Thomas gent 623693 623693 Fraunceys, Thomas, of Stepney, gent 0
4997011 2355958 2355958 defendant Aspeley Richard husbandman 623693 623693 Aspeley, Richard, of Stepney, husbandman 1
5193849 2413924 2413924 plaintiff Plesyngton John yeoman 623693 623693 Plesyngton, John, of Stepney, yeoman 0
5193850 2413924 2413924 defendant Spencer William yeoman 623693 623693 Spencer, William, of Stepney, yeoman 0
5193852 2413925 2413925 plaintiff Plesyngton John yeoman 623693 623693 Plesyngton, John, of Stepney, yeoman 0
5193853 2413925 2413925 defendant Spencer William yeoman 623693 623693 Spencer, William, of Stepney, yeoman 0
5208400 2418182 2418182 plaintiff Plesyngton John yeoman 623693 623693 Plesyngton, John, of Stepney, yeoman 0
5208401 2418182 2418182 defendant Spencer William yeoman 623693 623693 Spencer, William, of Stepney, yeoman 0
5208403 2418183 2418183 plaintiff Plesyngton John yeoman 623693 623693 Plesyngton, John, of Stepney, yeoman 0
5208404 2418183 2418183 defendant Spencer William yeoman 623693 623693 Spencer, William, of Stepney, yeoman 0
5209367 2418475 2418475 defendant Pool John yeoman 623693 623693 Pool, John, of Stepney, yeoman 0
5299531 2444840 2444840 defendant Culby Thomas butcher 623693 623693 Culby, Thomas, of Stepney, butcher 0
5299535 2444840 2444840 defendant Loyland John   623693 623693 Loyland, John, of Stepney, surgeon 4
5403007 2475942 2475942 defendant Thorp Richard esq 623693 623693 Thorp, Richard, of Stepney, esq 0
5416014 2479722 2479722 defendant Thorp Roger esq 623693 623693 Thorp, Roger, of Stepney, esq 0
5450636 2490074 2490074 plaintiff Radclyff Hugh gent 623693 623693 Radclyff, Hugh, of Stepney, 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);