names

34 rows where place_id = 601983

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3647905 1909742 1909742 defendant Wekton John husbandman 601983 601983 Wekton, John, of Flordon, husbandman 0
3676755 1918764 1918764 defendant Claxston Thomas husbandman 601983 601983 Claxston, Thomas, of Flordon, husbandman 0
3715441 1931116 1931116 defendant Fuller Robert husbandman 601983 601983 Fuller, Robert, of Flordon, husbandman 2
4012263 2029106 2029106 defendant Seman John clerk 601983 601983 Seman, John, of Flordon, clerk 1
4057026 2044897 2044897 defendant Seman John clerk 601983 601983 Seman, John, of Flordon, clerk 0
4058885 2045571 2045571 defendant Seman John clerk 601983 601983 Seman, John, of Flordon, clerk 2
4114147 2065341 2065341 defendant Wickham Philip tailor 601983 601983 Wickham, Philip, of Flordon, tailor 0
4114148 2065341 2065341 defendant Seman John clerk 601983 601983 Seman, John, of Flordon, clerk 1
4198011 2094853 2094853 defendant Seman John clerk 601983 601983 Seman, John, of Flordon, clerk 0
4227440 2105079 2105079 defendant Whitinge Thomas yeoman 601983 601983 Whitinge, Thomas, of Flordon, yeoman 0
4242865 2110605 2110605 defendant Whitinge Thomas husbandman 601983 601983 Whitinge, Thomas, of Flordon, husbandman 0
4244456 2111125 2111125 defendant Whitinge Thomas yeoman 601983 601983 Whitinge, Thomas, of Flordon, yeoman 0
4713474 2269535 2269535 defendant Louspe John yeoman 601983 601983 Louspe, John, of Flordon, yeoman 2
4884290 2321993 2321993 defendant Throwere John clerk 601983 601983 Throwere, John, of Flordon, clerk 2
4901156 2326979 2326979 defendant Gynne John husbandman 601983 601983 Gynne, John, of Flordon, husbandman 0
4901157 2326979 2326979 defendant Torald Robert husbandman 601983 601983 Torald, Robert, of Flordon, husbandman 1
4993563 2354948 2354948 defendant Ely Robert yeoman 601983 601983 Ely, Robert, of Flordon, yeoman 0
4993564 2354948 2354948 defendant Breweyn John yeoman 601983 601983 Breweyn, John, of Flordon, yeoman 1
4993565 2354948 2354948 defendant Knych John yeoman 601983 601983 Knych, John, of Flordon, yeoman 2
4993566 2354948 2354948 defendant Creweman William husbandman 601983 601983 Creweman, William, of Flordon, husbandman 3
5108918 2389029 2389029 defendant Brewyn John tailor 601983 601983 Brewyn, John, of Flordon, tailor 0
5108919 2389029 2389029 defendant Brewyn John laborer 601983 601983 Brewyn, John, of Flordon, laborer 1
5123727 2393399 2393399 defendant Wolvesley Thomas gent 601983 601983 together with Wolvesley, Thomas, of Flordon, gent 1
5123729 2393400 2393400 defendant Wolvesley Thomas gent 601983 601983 Wolvesley, Thomas, of Flordon, gent 0
5126071 2394107 2394107 defendant Wiveton David chaplain 601983 601983 Wiveton, David, of Flordon, chaplain 0
5134954 2396724 2396724 defendant Byxley William clerk & parson 601983 601983 Byxley, William, of Flordon, clerk & parson 4
5144694 2399604 2399604 defendant Kneton David chaplain 601983 601983 Kneton, David, of Flordon, chaplain 0
5155064 2402633 2402633 defendant Spire Robert clerk 601983 601983 Spire, Robert, of Flordon, clerk 2
5155085 2402637 2402637 defendant Byxley William clerk & parson 601983 601983 Byxley, William, of Flordon, clerk & parson 3
5171852 2407483 2407483 defendant Spyre Robert clerk & parson 601983 601983 Spyre, Robert, of Flordon, clerk & parson 2
5207012 2417788 2417788 defendant Spyre Robert clerk & parson 601983 601983 Spyre, Robert, of Flordon, clerk & parson 2
5354991 2461631 2461631 defendant Boyton Thomas laborer 601983 601983 Boyton, Thomas, of Flordon, laborer 1
5421598 2481397 2481397 defendant Langale John husbandman 601983 601983 Langale, John, of Flordon, husbandman 1
5454251 2491181 2491181 defendant Langale John husbandman 601983 601983 Langale, John, of Flordon, husbandman 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);