names

54 rows where place_id = 588521

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594803 1866002 1866002 defendant Fraunceys Thomas yeoman 588521 588521 Fraunceys, Thomas, of Pulham, Norf, yeoman 0
3600418 1867775 1867775 defendant Fraunseys Thomas yeoman 588521 588521 Fraunseys, Thomas, of Pulham, Norf, yeoman 0
3600577 1867827 1867827 defendant Fraunceys Thomas yeoman 588521 588521 Fraunceys, Thomas, of Pulham, Norf, yeoman 0
3601023 1867987 1867987 defendant Cokke John husbandman 588521 588521 Cokke, John, of Pulham, Norf, husbandman 3
3622787 1874657 1874657 defendant Caryon Alice widow 588521 588521 Caryon, Alice, of Pulham, Norf, widow, formerly Smethys, Alice, of Sandecroft, Norf, widow 0
3622790 1874658 1874658 defendant Wolnawe Thomas, junior husbandman 588521 588521 Wolnawe, Thomas, junior, of Pulham, Norf, husbandman 0
3628748 1903870 1903870 defendant Wolnawe William yeoman 588521 588521 Wolnawe, William, of Pulham, Norf, yeoman 0
3641916 1907925 1907925 defendant Aylme John pedder 588521 588521 Aylme, John, of Pulham, Norf, pedder 1
3664104 1914725 1914725 defendant Bruwyn Richard smith 588521 588521 Bruwyn, Richard, of Pulham, Norf, smith 0
3842430 1971167 1971167 plaintiff Broun John raffman 588521 588521 Broun, John, of Pulham, Norf, raffman 0
3866930 1979178 1979178 defendant Cobbe Robert husbandman 588521 588521 Cobbe, Robert, of Pulham, Norf, husbandman 3
4109835 2063776 2063776 defendant Bellward Robert yeoman 588521 588521 Bellward, Robert, of Pulham, Norf, yeoman 2
4276824 2121822 2121822 defendant Dymon Walter husbandman 588521 588521 Dymon, Walter, of Pulham, Norf, husbandman 1
4280464 2123074 2123074 defendant Brett Thomas tailor 588521 588521 Brett, Thomas, of Pulham, Norf, tailor 3
4674008 2257485 2257485 defendant Mayn Walter husbandman 588521 588521 Mayn, Walter, of Pulham, Norf, husbandman 1
4690707 2262641 2262641 defendant Wortham John yeoman 588521 588521 Wortham, John, of Pulham, Norf, yeoman 0
4719678 2271502 2271502 defendant Chele Robert butcher 588521 588521 Chele, Robert, of Pulham, Norf, butcher 2
4723800 2272746 2272746 defendant Shele Robert butcher 588521 588521 Shele, Robert, of Pulham, Norf, butcher 3
4760369 2283597 2283597 defendant Elmer Henry husbandman 588521 588521 Elmer, Henry, of Pulham, Norf, husbandman 1
4761859 2284052 2284052 defendant Coche William butcher 588521 588521 Coche, William, of Pulham, Norf, butcher 3
4770004 2286589 2286589 defendant Burgeys John yeoman 588521 588521 Burgeys, John, of Pulham, Norf, yeoman 2
4775156 2288224 2288224 defendant Thorn William husbandman 588521 588521 Thorn, William, of Pulham, Norf, husbandman 0
4777287 2288886 2288886 defendant Fage John gent 588521 588521 Fage, John, of Pulham, Norf, gent 0
4782781 2290630 2290630 defendant Elmer Henry husbandman 588521 588521 Elmer, Henry, of Pulham, Norf, husbandman 1
4782784 2290631 2290631 defendant Elmer Henry husbandman 588521 588521 Elmer, Henry, of Pulham, Norf, husbandman 1
4809997 2299284 2299284 defendant Taylour William husbandman 588521 588521 Taylour, William, of Pulham, Norf, husbandman 0
4817844 2301663 2301663 defendant Elmere Henry husbandman 588521 588521 Elmere, Henry, of Pulham, Norf, husbandman 1
4836233 2307312 2307312 defendant Tayllour William husbandman 588521 588521 Tayllour, William, of Pulham, Norf, husbandman 1
4836242 2307314 2307314 defendant Taillour William husbandman 588521 588521 Taillour, William, of Pulham, Norf, husbandman 1
4842605 2309224 2309224 defendant Codyngham John husbandman 588521 588521 Codyngham, John, of Pulham, Norf, husbandman 0
4850538 2311630 2311630 defendant Barkere Robert tanner 588521 588521 Barkere, Robert, of Pulham, Norf, tanner 0
4867860 2316920 2316920 defendant Wodeward Richard clerk 588521 588521 Wodeward, Richard, of Pulham, Norf, clerk 2
4867864 2316921 2316921 defendant Wodeward Richard clerk 588521 588521 Wodeward, Richard, of Pulham, Norf, clerk 2
5126953 2394362 2394362 defendant Elvare of Elbare Willam smith 588521 588521 Elvare of Elbare, Willam, of Pulham, Norf, smith 2
5127300 2394462 2394462 plaintiff Burre John   588521 588521 Burre, John, of Pulham, Norf 0
5146155 2400001 2400001 plaintiff Burre John   588521 588521 Burre, John, of Pulham, Norf 0
5166387 2405894 2405894 plaintiff Burre John   588521 588521 Burre, John, of Pulham, Norf 0
5175020 2408388 2408388 defendant Coole William   588521 588521 Coole, William, of Pulham, Norf, plough wright 1
5196015 2414582 2414582 defendant Coole William   588521 588521 Coole, William, of Pulham, Norf, plough wright 1
5196019 2414583 2414583 defendant Coole William   588521 588521 Coole, William, of Pulham, Norf, plough wright 1
5196165 2414624 2414624 defendant _ole William   588521 588521 _ole, William, of Pulham, Norf, plough wright 1
5246781 2429221 2429221 defendant Coole William   588521 588521 Coole, William, of Pulham, Norf, ploughwright 1
5252179 2430795 2430795 defendant Sherwyn Nicholas butcher 588521 588521 Sherwyn, Nicholas, of Pulham, Norf, butcher 0
5305236 2446569 2446569 defendant Motyberd Thomas husbandman 588521 588521 Motyberd, Thomas, of Pulham, Norf, husbandman 3
5354182 2461372 2461372 plaintiff Hanneworth John, junior husbandman 588521 588521 Hanneworth, John, junior, of Pulham, Norf, husbandman 1
5381196 2469678 2469678 defendant Russale Robert yeoman 588521 588521 Russale, Robert, of Pulham, Norf, yeoman 1
5381198 2469678 2469678 defendant Heyward John yeoman 588521 588521 Heyward, John, of Pulham, Norf, yeoman 3
5381199 2469678 2469678 defendant Stye John husbandman 588521 588521 Stye, John, of Pulham, Norf, husbandman 4
5381607 2469791 2469791 defendant Cooke John yeoman 588521 588521 Cooke, John, of Pulham, Norf, yeoman 3
5381613 2469792 2469792 defendant Cooke John yeoman 588521 588521 Cooke, John, of Pulham, Norf, yeoman 3
5382742 2470128 2470128 defendant Hanworth John yeoman 588521 588521 Hanworth, John, of Pulham, Norf, yeoman 0
5390985 2472487 2472487 defendant Cobbe John yeoman 588521 588521 Cobbe, John, of Pulham, Norf, yeoman 3
5406339 2476884 2476884 defendant Hanworth John fuller 588521 588521 Hanworth, John, of Pulham, Norf, yeoman. Herryes, Thomas, of Norwich, fuller 0
5589451 2531702 2531702 defendant Gobet John smith 588521 588521 Gobet, John, of Pulham, Norf, smith 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);