names

32 rows where place_id = 760812

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4473461 2192365 2192365 plaintiff Curlyngton John   760812 760812 Curlyngton, John, of Witteney 0
4658931 2248665 2248665 defendant Dougell Richard husbandman 760812 760812 Dougell, Richard, of Witteney, husbandman 0
4658932 2248665 2248665 defendant Hyworth William fuller 760812 760812 Hyworth, William, of Witteney, fuller 1
4662160 2249639 2249639 plaintiff Fleccher John   760812 760812 Fleccher, John, of Witteney 0
4662161 2249639 2249639 defendant Note John tailor 760812 760812 Note, John, of Witteney, tailor 0
4741407 2277983 2277983 defendant Martyn John woolman 760812 760812 Martyn, John, of Witteney, woolman 0
4743135 2278515 2278515 defendant Hostyler John hostiler 760812 760812 Hostyler, John, of Witteney, hostiler 1
4745214 2279106 2279106 defendant Radeford John tanner 760812 760812 Radeford, John, of Witteney, tanner 0
4753947 2281617 2281617 defendant Josteler John ostler 760812 760812 Josteler, John, of Witteney, ostler 0
4765327 2285139 2285139 defendant Brayn John fuller 760812 760812 Brayn, John, of Witteney, fuller 1
4767165 2285715 2285715 defendant Tamworth William husbandman 760812 760812 Tamworth, William, of Witteney, husbandman 1
4768389 2286083 2286083 defendant Radeford John husbandman 760812 760812 Radeford, John, of Witteney, husbandman 0
4779105 2289443 2289443 defendant Martyn John chapman 760812 760812 Martyn, John, of Witteney, chapman 0
4779108 2289444 2289444 defendant Hoode John, junior tanner 760812 760812 Hoode, John, junior, of Witteney, tanner 0
4779109 2289444 2289444 defendant Martyn John husbandman 760812 760812 Martyn, John, of Witteney, husbandman 1
4785652 2291540 2291540 defendant Radeford John chapman 760812 760812 Radeford, John, of Witteney, chapman 2
4789509 2292788 2292788 defendant Brayn John fuller 760812 760812 Brayn, John, of Witteney, fuller 1
4800232 2296249 2296249 defendant Lordyng John husbandman 760812 760812 Lordyng, John, of Witteney, husbandman 0
4903293 2327638 2327638 defendant Hikkys John husbandman 760812 760812 Hikkys, John, of Witteney, husbandman 1
4903294 2327638 2327638 defendant Dustlyng Thomas husbandman 760812 760812 Dustlyng, Thomas, of Witteney, husbandman 2
5039334 2368409 2368409 defendant Oliff John yeoman 760812 760812 Oliff, John, of Witteney, yeoman 4
5055170 2373124 2373124 defendant Harryotys Thomas husbandman 760812 760812 Harryotys, Thomas, of Witteney, husbandman 0
5055172 2373124 2373124 defendant Nobys Thomas husbandman 760812 760812 Nobys, Thomas, of Witteney, husbandman 2
5066335 2376460 2376460 defendant Nobys Thomas fuller 760812 760812 Nobys, Thomas, of Witteney, fuller 0
5066336 2376460 2376460 defendant Staunton William tailor 760812 760812 Staunton, William, of Witteney, tailor 1
5358896 2462833 2462833 defendant Forde John fisher 760812 760812 Forde, John, of Witteney, fisher 2
5427310 2483113 2483113 plaintiff Dusseling Richard fuller 760812 760812 Dusseling, Richard, of Witteney, fuller 0
5427311 2483113 2483113 defendant Ford Richard fishmonger 760812 760812 Ford, Richard, of Witteney, fishmonger 0
5430370 2484018 2484018 defendant Spycer Edward chapman 760812 760812 Spycer, Edward, of Witteney, chapman 2
5442576 2487695 2487695 defendant Cokkyn John yeoman 760812 760812 Cokkyn, John, of Witteney, yeoman 1
5446910 2488969 2488969 defendant Spycer Edward chapman 760812 760812 Spycer, Edward, of Witteney, chapman 1
5446966 2488984 2488984 defendant Spycer Edward chapman 760812 760812 Spycer, Edward, of Witteney, chapman 3

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);