names

22 rows where place_id = 609460

✎ 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
3678489 1919329 1919329 defendant Hanforde Richard husbandman 609460 609460 Hanforde, Richard, of Barnak, husbandman 1
3783450 1952572 1952572 defendant Vyncent William yeoman 609460 609460 Vyncent, William, of Barnak, yeoman 2
4591021 2228544 2228544 defendant Boudon John butcher 609460 609460 Boudon, John, of Barnak, butcher 0
4624817 2238742 2238742 defendant Smyth Thomas   609460 609460 Smyth, Thomas, of Barnak 7
4891031 2323935 2323935 defendant Cory John   609460 609460 Cory, John, of Barnak 0
4897605 2325914 2325914 plaintiff Eddirston John clerk 609460 609460 Eddirston, John, of Barnak, clerk 0
4897634 2325923 2325923 defendant Cory John gent 609460 609460 Cory, John, of Barnak, gent 0
4897636 2325924 2325924 defendant Cory John esq 609460 609460 Cory, John, of Barnak, esq 0
4905796 2328416 2328416 plaintiff Eddyrston John clerk 609460 609460 Eddyrston, John, of Barnak, clerk 0
4914037 2330900 2330900 plaintiff Cory John   609460 609460 Cory, John, of Barnak 0
5039395 2368428 2368428 defendant Vyncent William gent 609460 609460 Vyncent, William, of Barnak, gent 0
5048753 2371265 2371265 defendant Weldon John husbandman 609460 609460 Weldon, John, of Barnak, husbandman 0
5126443 2394208 2394208 defendant Smythe Thomas husbandman 609460 609460 Smythe, Thomas, of Barnak, husbandman 0
5139861 2398134 2398134 defendant barnak Thomas gent 609460 609460 barnak, Thomas, of Barnak, gent 0
5160863 2404274 2404274 defendant Barnak Thomas gent 609460 609460 Barnak, Thomas, of Barnak, gent 0
5160865 2404275 2404275 defendant Barnak Thomas gent 609460 609460 Barnak, Thomas, of Barnak, gent 0
5232423 2425057 2425057 defendant Boteler Elizabeth widow 609460 609460 Boteler, Elizabeth, of Barnak, widow 0
5247179 2429332 2429332 defendant Bocher Richard butcher 609460 609460 Bocher, Richard, of Barnak, butcher 1
5509714 2507869 2507869 defendant Welesby Thomas laborer 609460 609460 Welesby, Thomas, of Barnak, laborer 1
5520360 2511189 2511189 defendant Monk William gent 609460 609460 Monk, William, of Barnak, gent 0
5532874 2514823 2514823 defendant Monke John gent 609460 609460 Monke, John, of Barnak, gent 0
5591895 2532450 2532450 defendant Wilkynson Richard yeoman 609460 609460 Wilkynson, Richard, of Barnak, yeoman 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);