names

23 rows where place_id = 602490

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3650411 1910498 1910498 defendant Hunt Henry carpenter 602490 602490 Hunt, Henry, of West Wrattyng, carpenter 0
3752922 1942841 1942841 defendant Seman John husbandman 602490 602490 Seman, John, of West Wrattyng, husbandman 0
3838889 1970090 1970090 defendant Mansforthe John carpenter 602490 602490 Mansforthe, John, of West Wrattyng, carpenter 1
3934761 2001923 2001923 defendant Westley John   602490 602490 Westley, John, of West Wrattyng, hurdle maker 0
3998891 2024362 2024362 defendant Maynford John carpenter 602490 602490 Maynford, John, of West Wrattyng, carpenter 0
4010031 2028354 2028354 defendant Harte alias Goodchelde John butcher 602490 602490 Harte alias Goodchelde, John, of West Wrattyng, butcher 0
4013960 2029727 2029727 defendant Maynford John yeoman or horse courser 602490 602490 Maynford, John, of West Wrattyng, yeoman or horse courser 0
4300894 2130419 2130419 defendant Hood Thomas, junior husbandman 602490 602490 Hood, Thomas, junior, of West Wrattyng, husbandman 0
4339162 2143457 2143457 defendant Wolward William yeoman 602490 602490 Wolward, William, of West Wrattyng, yeoman 0
4355139 2149015 2149015 defendant Page John miller 602490 602490 Page, John, of West Wrattyng, miller 0
4654387 2247245 2247245 defendant Teveresham Thomas butcher 602490 602490 Teveresham, Thomas, of West Wrattyng, butcher 0
4669160 2256061 2256061 defendant Taveresham Thomas laborer 602490 602490 Taveresham, Thomas, of West Wrattyng, laborer 0
4765656 2285251 2285251 defendant Froge John husbandman 602490 602490 Froge, John, of West Wrattyng, husbandman 0
4773901 2287816 2287816 defendant Foot Thomas husbandman 602490 602490 Foot, Thomas, of West Wrattyng, husbandman 0
4782190 2290429 2290429 defendant Vale Robert husbandman 602490 602490 Vale, Robert, of West Wrattyng, husbandman 0
4834092 2306669 2306669 defendant Bunt Thomas husbandman 602490 602490 Bunt, Thomas, of West Wrattyng, husbandman 0
4925357 2334365 2334365 plaintiff Pelter William skinner 602490 602490 Pelter, William, of West Wrattyng, skinner 0
4938618 2338463 2338463 defendant Bunt Thomas yeoman 602490 602490 Bunt, Thomas, of West Wrattyng, yeoman 0
5143600 2399264 2399264 defendant Williamson John clerk 602490 602490 Williamson, John, of West Wrattyng, clerk 4
5143621 2399268 2399268 defendant Williamson John clerk 602490 602490 Williamson, John, of West Wrattyng, clerk 4
5244443 2428558 2428558 defendant Ryot John husbandman 602490 602490 Ryot, John, of West Wrattyng, husbandman 0
5561512 2523346 2523346 defendant Stevynton John husbandman 602490 602490 Stevynton, John, of West Wrattyng, husbandman 0
5589231 2531637 2531637 defendant Ball John tailor 602490 602490 Ball, John, of West Wrattyng, tailor 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);