names

80 rows where place_id = 758451

✎ 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
4420844 2171416 2171416 defendant Boketot Philip   758451 758451 Boketot, Philip, of Buckinghamshire, knight 1
4426831 2173210 2173210 defendant Boketon Philip   758451 758451 Boketon, Philip, of Buckinghamshire, knight 1
4432347 2174897 2174897 defendant Barre Celia   758451 758451 Barre, Celia, of Buckinghamshire, formerly wife of Robert 0
4433446 2175221 2175221 defendant Molyns John de   758451 758451 Molyns, John de, of Buckinghamshire, knight 0
4453980 2186261 2186261 defendant Mildecombe Walter   758451 758451 Mildecombe, Walter, of Buckinghamshire 0
4464873 2189681 2189681 defendant Badby Jonn   758451 758451 Badby, Jonn, of Buckinghamshire 1
4469825 2191232 2191232 defendant Colyn John   758451 758451 Colyn, John, of Buckinghamshire 8
4469832 2191233 2191233 defendant Coly John   758451 758451 Coly, John, of Buckinghamshire 3
4490696 2197791 2197791 defendant Parker Richard   758451 758451 Parker, Richard, of Buckinghamshire 0
4492251 2198258 2198258 defendant Bylynden Henry   758451 758451 Bylynden, Henry, of Buckinghamshire 0
4492258 2198259 2198259 defendant Bylynden Henry   758451 758451 Bylynden, Henry, of Buckinghamshire 0
4499436 2200474 2200474 defendant Wendovere Thomas   758451 758451 Wendovere, Thomas, of Buckinghamshire 1
4510621 2203779 2203779 defendant Saddok Henry chapman 758451 758451 Saddok, Henry, of Buckinghamshire, chapman 2
4510628 2203780 2203780 defendant Saddok Henry chapman 758451 758451 Saddok, Henry, of Buckinghamshire, chapman 2
4510652 2203789 2203789 plaintiff Barton John, sen   758451 758451 Barton, John, sen, of Buckinghamshire 0
4544409 2214161 2214161 plaintiff Barton John   758451 758451 Barton, John, of Buckinghamshire 0
4550570 2216122 2216122 plaintiff Dayrell Roger   758451 758451 Dayrell, Roger, of Buckinghamshire 0
4553202 2216935 2216935 defendant Bredenell Henry esq 758451 758451 Bredenell, Henry, of Buckinghamshire, esq 1
4555068 2217514 2217514 defendant Coteler John clerk 758451 758451 Coteler, John, of Buckinghamshire, clerk 0
4566469 2221081 2221081 defendant Hale Ralph   758451 758451 Hale, Ralph, of Buckinghamshire 0
4566473 2221082 2221082 defendant Hale Ralph   758451 758451 Hale, Ralph, of Buckinghamshire 0
4567965 2221549 2221549 defendant Torpyng John   758451 758451 Torpyng, John, of Buckinghamshire 0
4574287 2223487 2223487 defendant Colryg Bartholomew   758451 758451 Colryg, Bartholomew, of Buckinghamshire 1
4583178 2226163 2226163 defendant Mathewe John   758451 758451 Mathewe, John, of Buckinghamshire 2
4584316 2226504 2226504 defendant Woloten Thomas brewer 758451 758451 Woloten, Thomas, of Buckinghamshire, formerly of London, brewer 1
4584326 2226507 2226507 defendant Woborn Thomas   758451 758451 Woborn, Thomas, of Buckinghamshire, formerly brewer of London 1
4584911 2226713 2226713 defendant Clyfford John   758451 758451 Clyfford, John, of Buckinghamshire 0
4585863 2226999 2226999 defendant Helpesthrop Thomas   758451 758451 Helpesthrop, Thomas, of Buckinghamshire 3
4592990 2229124 2229124 defendant Bull William   758451 758451 Bull, William, of Buckinghamshire 4
4596602 2230173 2230173 defendant Saunturdon Bernard esq 758451 758451 Saunturdon, Bernard, of Buckinghamshire, esq 1
4596605 2230173 2230173 defendant Newenham John esq 758451 758451 Newenham, John, of Buckinghamshire, esq 4
4597220 2230374 2230374 defendant Duraunt Thomas   758451 758451 Duraunt, Thomas, of Buckinghamshire 1
4597223 2230375 2230375 defendant Duraunt Thomas   758451 758451 Duraunt, Thomas, of Buckinghamshire 1
4600621 2231422 2231422 defendant Boys William esq 758451 758451 Boys, William, of Buckinghamshire, esq 0
4604724 2232643 2232643 defendant Bracy Guy esq 758451 758451 Bracy, Guy, of Buckinghamshire, esq 1
4604817 2232675 2232675 defendant Fleccher Walter   758451 758451 Fleccher, Walter, of Buckinghamshire 0
4617376 2236447 2236447 defendant Lemes William   758451 758451 Lemes, William, of Buckinghamshire 3
4622078 2237885 2237885 defendant Graunton John de clerk 758451 758451 Graunton, John de, of Buckinghamshire, clerk 0
4622338 2237965 2237965 defendant Newenham John   758451 758451 Newenham, John, of Buckinghamshire 2
4624163 2238537 2238537 defendant Bertlot Richard   758451 758451 Bertlot, Richard, of Buckinghamshire 1
4630519 2240457 2240457 defendant Domere John   758451 758451 Domere, John, of Buckinghamshire 0
4630749 2240509 2240509 defendant Chaumbre John   758451 758451 Chaumbre, John, of Buckinghamshire, knight 6
4632933 2241171 2241171 defendant Assenden Adam   758451 758451 Assenden, Adam, of Buckinghamshire 1
4633041 2241203 2241203 defendant Rolf Thomas   758451 758451 Rolf, Thomas, of Buckinghamshire 0
4636938 2242363 2242363 defendant Bradewater William   758451 758451 Bradewater, William, of Buckinghamshire 5
4636945 2242364 2242364 defendant Bradewater William   758451 758451 Bradewater, William, of Buckinghamshire 5
4638094 2242677 2242677 defendant Wykefeld Thomas   758451 758451 Wykefeld, Thomas, of Buckinghamshire 1
4640799 2243410 2243410 defendant Lyngyn Hugh   758451 758451 Lyngyn, Hugh, of Buckinghamshire 3
4641300 2243549 2243549 defendant Purtas John   758451 758451 Purtas, John, of Buckinghamshire 0
4650173 2246072 2246072 defendant Bracey Guy esq 758451 758451 Bracey, Guy, of Buckinghamshire, esq 2
4680311 2259454 2259454 plaintiff Letterford Thomas   758451 758451 Letterford, Thomas, of Buckinghamshire 1
4680730 2259590 2259590 plaintiff Lucy Reginald   758451 758451 Lucy, Reginald, of Buckinghamshire, knight 0
4680732 2259591 2259591 plaintiff Lucy Reginald   758451 758451 Lucy, Reginald, of Buckinghamshire, knight 0
4705936 2267234 2267234 plaintiff Letterford Thomas   758451 758451 Letterford, Thomas, of Buckinghamshire 1
4729623 2274477 2274477 plaintiff Letterford Thomas   758451 758451 Letterford, Thomas, of Buckinghamshire 1
4769808 2286532 2286532 defendant Ardern William   758451 758451 Ardern, William, of Buckinghamshire 0
4814553 2300661 2300661 plaintiff Hiester William   758451 758451 Hiester, William, of Buckinghamshire 1
5050064 2371641 2371641 defendant Massy William (legal representative) 758451 758451 Massy, William, of Buckinghamshire, esq, executors of 0
5125773 2394022 2394022 defendant Baldewyn John   758451 758451 Baldewyn, John, of Buckinghamshire 1
5144386 2399514 2399514 plaintiff Baldewyn John gent 758451 758451 Baldewyn, John, of Buckinghamshire, gent 2
5165260 2405582 2405582 plaintiff Baldewyn John gent 758451 758451 Baldewyn, John, of Buckinghamshire, gent 2
5165924 2405779 2405779 defendant Brocas Bernard (legal representative) 758451 758451 Brocas, Bernard, of Buckinghamshire, esq, executors of 0
5180519 2410049 2410049 defendant Brocas Bernard (legal representative) 758451 758451 Brocas, Bernard, of Buckinghamshire, esq, executors of 0
5180524 2410050 2410050 defendant Brocas Bernard (legal representative) 758451 758451 Brocas, Bernard, of Buckinghamshire, esq, executors of 0
5180544 2410055 2410055 defendant Brocas Bernard (legal representative) 758451 758451 Brocas, Bernard, of Buckinghamshire, esq, executors of 0
5193059 2413700 2413700 defendant Fawconer William husbandman 758451 758451 Fawconer, William, of Buckinghamshire, husbandman 0
5202463 2416483 2416483 defendant Brocas Bernard (legal representative) 758451 758451 Brocas, Bernard, of Buckinghamshire, esq, executor of 0
5202468 2416484 2416484 defendant Brocas Bernard (legal representative) 758451 758451 Brocas, Bernard, of Buckinghamshire, esq, executors of 0
5275926 2438031 2438031 plaintiff Teryngham John esq 758451 758451 Teryngham, John, of Buckinghamshire, esq 0
5301569 2445423 2445423 plaintiff Dayrell Paul gent 758451 758451 Dayrell, Paul, of Buckinghamshire, gent 0
5397060 2474243 2474243 plaintiff Broughton John   758451 758451 Broughton, John, of Buckinghamshire, senior, sheriff 0
5397186 2474280 2474280 plaintiff Brudenell Drew   758451 758451 Brudenell, Drew, of Buckinghamshire, sheriff 0
5397918 2474478 2474478 defendant Swaune William gent 758451 758451 Swaune, William, of Buckinghamshire, gent 0
5413608 2478995 2478995 plaintiff Gate Thomas brother of the present King 758451 758451 Gate, Thomas, of Buckinghamshire, escheator for King Edward, brother of the present King 0
5418395 2480429 2480429 defendant Restwold (illegible) gent 758451 758451 Restwold, _, of Buckinghamshire, gent 2
5419107 2480642 2480642 defendant Alchon Thomas tanner 758451 758451 Alchon, Thomas, of Buckinghamshire, tanner 0
5424227 2482212 2482212 plaintiff Brudenell Drew   758451 758451 Brudenell, Drew, of Buckinghamshire, formerly sheriff 0
5433260 2484912 2484912 plaintiff Meryden John yeoman 758451 758451 Meryden, John, of Buckinghamshire, yeoman 0
5454143 2491135 2491135 defendant Saunders William dyer 758451 758451 Saunders, William, of Buckinghamshire, dyer 2
5619619 2549989 2549989 defendant Gunald John   758451 758451 Gunald, John, of Buckinghamshire 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);