names

45 rows where place_id = 596212

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3623705 1874947 1874947 defendant Pereson William miller 596212 596212 Pereson, William, of Saperton, miller 0
3623706 1874947 1874947 defendant Wryght John husbandman 596212 596212 Wryght, John, of Saperton, husbandman 1
3635859 1906014 1906014 defendant Marchal Thomas clerk 596212 596212 Marchal, Thomas, of Saperton, clerk 1
3635860 1906014 1906014 defendant Wattys William husbandman 596212 596212 Wattys, William, of Saperton, husbandman 2
3756338 1943949 1943949 defendant Pole Leonard gent 596212 596212 Pole, Leonard, of Saperton, gent 0
3852558 1974409 1974409 defendant Mannyng William clerk 596212 596212 Mannyng, William, of Saperton, clerk 1
3965335 2012493 2012493 defendant Rolle Richard husbandman 596212 596212 Rolle, Richard, of Saperton, husbandman 0
3965336 2012493 2012493 defendant Rolle George joiner 596212 596212 Rolle, George, of Saperton, joiner 1
4020669 2032120 2032120 defendant Middelton William gent 596212 596212 Middelton, William, of Saperton, gent 1
4101981 2061017 2061017 defendant Imbryes William husbandman 596212 596212 Imbryes, William, of Saperton, husbandman 1
4101984 2061018 2061018 defendant Imbryes William husbandman 596212 596212 Imbryes, William, of Saperton, husbandman 1
4180967 2088820 2088820 defendant Parsons William weaver 596212 596212 Parsons, William, of Saperton, weaver 0
4525661 2208328 2208328 defendant Saperton John del   596212 596212 Saperton, John del, of Saperton 3
4534403 2211032 2211032 defendant Toures Thomas   596212 596212 Toures, Thomas, of Saperton, parson 0
4632490 2241051 2241051 defendant Clerk John   596212 596212 Clerk, John, of Saperton 0
4666125 2250872 2250872 defendant Wilsforde John husbandman 596212 596212 Wilsforde, John, of Saperton, husbandman 0
4679857 2259306 2259306 plaintiff Lane John   596212 596212 Lane, John, of Saperton 0
4684938 2260882 2260882 defendant Saperton John, junior gent 596212 596212 Saperton, John, junior, of Saperton, gent 1
4698432 2264986 2264986 defendant Saperton John husbandman 596212 596212 Saperton, John, of Saperton, husbandman 0
4753958 2281620 2281620 defendant Clerk Thomas laborer 596212 596212 Clerk, Thomas, of Saperton, laborer 0
4769421 2286411 2286411 defendant Taillour John laborer 596212 596212 Taillour, John, of Saperton, laborer 0
4829713 2305339 2305339 plaintiff Clerk John   596212 596212 Clerk, John, of Saperton 4
4835852 2307201 2307201 defendant Leveryngton John   596212 596212 Leveryngton, John, of Saperton 7
4892752 2324458 2324458 plaintiff Scot John   596212 596212 Scot, John, of Saperton 0
4992124 2354536 2354536 defendant Quynsy William husbandman 596212 596212 Quynsy, William, of Saperton, husbandman 0
4992125 2354536 2354536 defendant Quynsy Thomas husbandman 596212 596212 Quynsy, Thomas, of Saperton, husbandman 1
5080272 2380589 2380589 defendant Colme Thomas husbandman 596212 596212 Colme, Thomas, of Saperton, husbandman 0
5080273 2380589 2380589 defendant Colme Robert   596212 596212 Colme, Robert, of Saperton, servant 1
5080274 2380589 2380589 defendant Horn Thomas weaver 596212 596212 Horn, Thomas, of Saperton, weaver 2
5080275 2380589 2380589 defendant Quynce Thomas husbandman 596212 596212 Quynce, Thomas, of Saperton, husbandman 3
5210391 2418771 2418771 defendant Quynsey Thomas husbandman 596212 596212 Quynsey, Thomas, of Saperton, husbandman 7
5341736 2457608 2457608 defendant Tables William husbandman 596212 596212 Tables, William, of Saperton, husbandman 0
5431315 2484315 2484315 defendant Neweman John husbandman 596212 596212 Neweman, John, of Saperton, husbandman 0
5431316 2484315 2484315 defendant Wyneyard John husbandman 596212 596212 Wyneyard, John, of Saperton, husbandman 1
5439742 2486828 2486828 defendant Horne William weaver 596212 596212 Horne, William, of Saperton, weaver 2
5447790 2489219 2489219 defendant Neweman John husbandman 596212 596212 Neweman, John, of Saperton, husbandman 0
5447791 2489219 2489219 defendant Wyneard John husbandman 596212 596212 Wyneard, John, of Saperton, husbandman 1
5460171 2492976 2492976 defendant Neweman John husbandman 596212 596212 Neweman, John, of Saperton, husbandman 0
5460172 2492976 2492976 defendant Wyneyard John husbandman 596212 596212 Wyneyard, John, of Saperton, husbandman 1
5460174 2492977 2492977 defendant Neweman John husbandman 596212 596212 Neweman, John, of Saperton, husbandman 0
5460175 2492977 2492977 defendant Wyneyard John husbandman 596212 596212 Wyneyard, John, of Saperton, husbandman 1
5460177 2492978 2492978 defendant Neweman John husbandman 596212 596212 Neweman, John, of Saperton, husbandman 0
5460178 2492978 2492978 defendant Wyneyard John husbandman 596212 596212 Wyneyard, John, of Saperton, husbandman 1
5526285 2512801 2512801 defendant Bisse William husbandman 596212 596212 Bisse, William, of Saperton, husbandman 0
5627173 2552463 2552463 defendant Saperton John   596212 596212 Saperton, John, of Saperton 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);