names

15 rows where place_id = 586545

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589002 1864211 1864211 defendant Sherard James gent 586545 586545 Sherard, James, of Napton, Warks, gent 1
4004272 2026308 2026308 defendant Shuckburghe John gent 586545 586545 Shuckburghe, John, of Napton, Warks, gent 0
4006436 2027080 2027080 defendant Elwarde William yeoman 586545 586545 Elwarde, William, of Napton, Warks, yeoman 0
4019395 2031670 2031670 defendant Fawkner Edward yeoman 586545 586545 Fawkner, Edward, of Napton, Warks, yeoman 1
4032143 2036163 2036163 defendant Tofte William yeoman 586545 586545 Tofte, William, of Napton, Warks, yeoman 0
4032145 2036164 2036164 defendant Togte William yeoman 586545 586545 Togte, William, of Napton, Warks, yeoman 0
4038742 2038484 2038484 defendant Tofte William yeoman 586545 586545 Tofte, William, of Napton, Warks, yeoman 1
4038749 2038485 2038485 defendant Tofte William yeoman 586545 586545 Tofte, William, of Napton, Warks, yeoman 1
4116722 2066277 2066277 defendant Oldefelde Thomas gent 586545 586545 Oldefelde, Thomas, of Napton, Warks, gent 0
4152879 2079116 2079116 defendant Oldfeild Thomas gent 586545 586545 Oldfeild, Thomas, of Napton, Warks, gent 0
4776313 2288585 2288585 defendant Broun John chapman 586545 586545 Broun, John, of Napton, Warks, chapman 1
4776317 2288586 2288586 defendant Broun John chapman 586545 586545 Broun, John, of Napton, Warks, chapman 1
4780296 2289838 2289838 defendant Broun John husbandman 586545 586545 Broun, John, of Napton, Warks, husbandman 3
4861630 2315010 2315010 defendant Hayton Thomas gent 586545 586545 Hayton, Thomas, of Napton, Warks, gent 0
5221028 2421850 2421850 defendant Venabuls Peter gent 586545 586545 Venabuls, Peter, of Napton, Warks, 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);