names

22 rows where place_id = 641476

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3861819 1977413 1977413 defendant Lese Martin yeoman 641476 641476 Lese, Martin, of Baslowe, yeoman 3
3875901 1982194 1982194 defendant Lees Martin husbandman 641476 641476 Lees, Martin, of Baslowe, husbandman 1
3888872 1986526 1986526 defendant Andrewe William husbandman 641476 641476 Andrewe, William, of Baslowe, husbandman 2
3888873 1986526 1986526 defendant Lees Martin   641476 641476 Lees, Martin, of Baslowe 3
3903452 1991381 1991381 defendant Wode Robert husbandman 641476 641476 Wode, Robert, of Baslowe, husbandman 1
3925525 1998847 1998847 plaintiff Wode Robert   641476 641476 Wode, Robert, of Baslowe 0
4157469 2080686 2080686 defendant Atkinson Thomas laborer 641476 641476 Atkinson, Thomas, of Baslowe, laborer 0
4159912 2081535 2081535 defendant Yelott Henry   641476 641476 Yelott, Henry, of Baslowe, "stonpecker" 0
4159913 2081535 2081535 defendant Wylde Thomas   641476 641476 Wylde, Thomas, of Baslowe, "stonpecker" 1
4159914 2081535 2081535 defendant Howton Thomas   641476 641476 Howton, Thomas, of Baslowe, "stonpecker" 2
4159915 2081535 2081535 defendant Baslowe Richard   641476 641476 Baslowe, Richard, of Baslowe, "stonpecker" 3
4195393 2093935 2093935 defendant Botham John, junior laborer 641476 641476 Botham, John, junior, of Baslowe, laborer 0
4214440 2100558 2100558 defendant North alias Cooke John, junior miner 641476 641476 North alias Cooke, John, junior, of Baslowe, laborer, Fynnye, Robert, of Bakewell, miner 1
4222877 2103489 2103489 defendant Needham George   641476 641476 Needham, George, of Baslowe, millstone maker 1
4410634 2168147 2168147 defendant Thomas John yeoman 641476 641476 Thomas, John, of Baslowe, yeoman 0
4572066 2222827 2222827 defendant Leche William   641476 641476 Leche, William, of Baslowe 6
4689121 2262159 2262159 defendant Pennyston Joan widow & formerly wife of John Pennyston 641476 641476 Pennyston, Joan, of Baslowe, widow & formerly wife of John Pennyston 0
4748747 2280119 2280119 defendant Meverell John husbandman 641476 641476 Meverell, John, of Baslowe, husbandman 0
4748748 2280119 2280119 defendant Pope Robert husbandman 641476 641476 Pope, Robert, of Baslowe, husbandman 1
4908926 2329337 2329337 defendant Wasse Roger husbandman 641476 641476 Wasse, Roger, of Baslowe, husbandman 1
4960024 2344963 2344963 defendant Vesse Roger husbandman 641476 641476 Vesse, Roger, of Baslowe, husbandman 2
5412768 2478768 2478768 defendant Sellers William carrier 641476 641476 Sellers, William, of Baslowe, carrier 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);