names

40 rows where place_id = 621488

✎ 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
3741741 1939279 1939279 defendant Lawnce Richard husbandman 621488 621488 Lawnce, Richard, of Ilton, husbandman 0
3885123 1985281 1985281 defendant Mathew Thomas butcher 621488 621488 Mathew, Thomas, of Ilton, butcher 0
3885124 1985281 1985281 defendant Meyde Richard husbandman 621488 621488 Meyde, Richard, of Ilton, husbandman 1
3885194 1985299 1985299 plaintiff Baly John yeoman 621488 621488 Baly, John, of Ilton, yeoman 0
3885195 1985299 1985299 defendant Thomas John tailor 621488 621488 Thomas, John, of Ilton, tailor 0
3920328 1997140 1997140 plaintiff Meade Thurstan husbandman 621488 621488 Meade, Thurstan, of Ilton, husbandman 0
3981932 2018299 2018299 defendant Thomas John yeoman 621488 621488 Thomas, John, of Ilton, yeoman 0
4008830 2027920 2027920 defendant Dwellye or Dewellye Peter tailor 621488 621488 Dwellye or Dewellye, Peter, of Ilton, tailor 0
4008832 2027921 2027921 defendant Thomas John, junior yeoman 621488 621488 Thomas, John, junior, of Ilton, yeoman 0
4038216 2038302 2038302 defendant Thomas John yeoman 621488 621488 Thomas, John, of Ilton, yeoman 0
4070077 2049587 2049587 defendant Lindon Thomas clothier 621488 621488 Lindon, Thomas, of Ilton, clothier 2
4077584 2052271 2052271 defendant Beven Elias gent 621488 621488 Beven, Elias, of Ilton, gent 0
4077841 2052374 2052374 defendant Belyn Elias gent 621488 621488 Belyn, Elias, of Ilton, gent 0
4078228 2052516 2052516 defendant Thomas John, junior yeoman 621488 621488 Thomas, John, junior, of Ilton, yeoman 0
4078229 2052516 2052516 defendant Thomas John, senior yeoman 621488 621488 Thomas, John, senior, of Ilton, yeoman 1
4286846 2125352 2125352 defendant Hawker Christopher husbandman 621488 621488 Hawker, Christopher, of Ilton, husbandman 0
4441349 2182230 2182230 defendant Hastynges William   621488 621488 Hastynges, William, of Ilton 1
4507707 2202871 2202871 defendant Tromper Thomas   621488 621488 Tromper, Thomas, of Ilton 5
4589078 2227963 2227963 defendant atte Yoo Thomas   621488 621488 atte Yoo, Thomas, of Ilton 0
4632668 2241103 2241103 defendant Clerk John   621488 621488 Clerk, John, of Ilton 0
4673131 2257238 2257238 defendant Poulter William husbandman 621488 621488 Poulter, William, of Ilton, husbandman 0
4687743 2261739 2261739 defendant Clerk John laborer 621488 621488 Clerk, John, of Ilton, laborer 2
4702686 2266240 2266240 defendant Francome John tailor 621488 621488 Francome, John, of Ilton, tailor 1
4733907 2275789 2275789 defendant Clerk John husbandman 621488 621488 Clerk, John, of Ilton, husbandman 0
4750541 2280641 2280641 defendant Cremelford John husbandman 621488 621488 Cremelford, John, of Ilton, husbandman 3
4785077 2291346 2291346 defendant Fyers John chapman 621488 621488 Fyers, John, of Ilton, chapman 2
4961602 2345433 2345433 defendant Baker Robert husbandman 621488 621488 Baker, Robert, of Ilton, husbandman 0
4978642 2350560 2350560 defendant Muttylbury Robert husbandman 621488 621488 together with Muttylbury, Robert, of Ilton, husbandman 1
5067879 2376891 2376891 defendant Baker Robert husbandman 621488 621488 Baker, Robert, of Ilton, husbandman 3
5087418 2382697 2382697 defendant Cabell Richard yeoman 621488 621488 Cabell, Richard, of Ilton, yeoman 0
5158292 2403549 2403549 defendant Were Edward husbandman 621488 621488 Were, Edward, of Ilton, husbandman 0
5194200 2414034 2414034 defendant Were Edward husbandman 621488 621488 Were, Edward, of Ilton, husbandman 0
5286065 2440933 2440933 defendant Dawe John husbandman 621488 621488 Dawe, John, of Ilton, husbandman 1
5341279 2457464 2457464 defendant Westlake John   621488 621488 Westlake, John, of Ilton, groom 0
5341280 2457464 2457464 defendant Westlake William husbandman 621488 621488 Westlake, William, of Ilton, husbandman 1
5360960 2463451 2463451 defendant Ricard John clerk 621488 621488 Ricard, John, of Ilton, clerk 0
5510880 2508244 2508244 defendant Clerke William husbandman 621488 621488 Clerke, William, of Ilton, husbandman 0
5510881 2508244 2508244 defendant Clerke John husbandman 621488 621488 Clerke, John, of Ilton, husbandman 1
5584863 2530344 2530344 defendant Raggelond John clerk 621488 621488 Raggelond, John, of Ilton, clerk 0
5611146 2547212 2547212 defendant Frye William   621488 621488 Frye, William, of Ilton 1

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