names

50 rows where place_id = 760279

✎ 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
4468656 2190869 2190869 plaintiff Bekyngham Thomas de   760279 760279 Bekyngham, Thomas de, of Mauby 0
4471555 2191764 2191764 defendant Jamson Robert   760279 760279 Jamson, Robert, of Mauby 0
4517450 2205858 2205858 defendant Hill John de   760279 760279 Hill, John de, of Mauby, parson 0
4517452 2205858 2205858 defendant Count William   760279 760279 Count, William, of Mauby 2
4517453 2205858 2205858 defendant Totill John   760279 760279 Totill, John, of Mauby 3
4517454 2205858 2205858 defendant Holme William de   760279 760279 Holme, William de, of Mauby 4
4517455 2205858 2205858 defendant Holme Robert   760279 760279 Holme, Robert, of Mauby 5
4517458 2205858 2205858 defendant Wyot John   760279 760279 Wyot, John, of Mauby 8
4517459 2205858 2205858 defendant Wyt_ William   760279 760279 Wyt_, William, of Mauby 9
4517460 2205858 2205858 defendant Godetyme Alan   760279 760279 Godetyme, Alan, of Mauby 10
4517462 2205858 2205858 defendant Peronell Thomas   760279 760279 Peronell, Thomas, of Mauby 12
4517463 2205858 2205858 defendant Hawelay Simon   760279 760279 Hawelay, Simon, of Mauby 13
4517464 2205858 2205858 defendant Harpham William   760279 760279 Harpham, William, of Mauby 14
4517466 2205858 2205858 defendant Smyth Thomas   760279 760279 Smyth, Thomas, of Mauby, son of John 16
4540723 2213005 2213005 plaintiff Whelewright William   760279 760279 Whelewright, William, of Mauby 0
4542566 2213559 2213559 defendant (illegible) Thomas   760279 760279 _, Thomas, of Mauby 0
4544814 2214297 2214297 plaintiff Bekyngham Thomas   760279 760279 Bekyngham, Thomas, of Mauby 0
4566980 2221234 2221234 defendant Bekyngham Thomas   760279 760279 Bekyngham, Thomas, of Mauby 2
4570772 2222431 2222431 defendant Fotherby Walter de   760279 760279 Fotherby, Walter de, of Mauby 0
4608619 2233801 2233801 defendant del Hill John   760279 760279 del Hill, John, of Mauby, parson 0
4755708 2282169 2282169 defendant Wryght Adam husbandman 760279 760279 Wryght, Adam, of Mauby, husbandman 0
4759329 2283263 2283263 defendant Miller Thomas husbandman 760279 760279 Miller, Thomas, of Mauby, husbandman 0
4775674 2288388 2288388 defendant Drowery Waltler   760279 760279 Drowery, Waltler, of Mauby, franklin 0
4818414 2301840 2301840 defendant Wryght Adam husbandman 760279 760279 Wryght, Adam, of Mauby, husbandman 0
4911630 2330138 2330138 defendant Tomson Robert husbandman 760279 760279 Tomson, Robert, of Mauby, husbandman 2
5161784 2404552 2404552 defendant Underwode Gilbert husbandman 760279 760279 Underwode, Gilbert, of Mauby, husbandman 0
5176065 2408684 2408684 defendant Underwode Gilbert husbandman 760279 760279 Underwode, Gilbert, of Mauby, husbandman 0
5197908 2415126 2415126 defendant Underwode Gilbert husbandman 760279 760279 Underwode, Gilbert, of Mauby, husbandman 0
5307645 2447302 2447302 defendant Underwode Gilbert husbandman 760279 760279 Underwode, Gilbert, of Mauby, husbandman 0
5307646 2447302 2447302 defendant Skotte William husbandman 760279 760279 Skotte, William, of Mauby, husbandman 1
5399615 2474973 2474973 defendant Skupholme William yeoman 760279 760279 Skupholme, William, of Mauby, yeoman 0
5407295 2477150 2477150 plaintiff Wake William (legal representative) 760279 760279 Wake, William, of Mauby, administratrix of 0
5407298 2477150 2477150 defendant Kymyerdby John husbandman 760279 760279 Kymyerdby, John, of Mauby, husbandman 1
5412624 2478722 2478722 defendant Skupholme William yeoman 760279 760279 Skupholme, William, of Mauby, yeoman 0
5419990 2480895 2480895 defendant Skopholm William husbandman 760279 760279 Skopholm, William, of Mauby, husbandman 0
5419991 2480895 2480895 defendant Skopholm John laborer 760279 760279 Skopholm, John, of Mauby, laborer 1
5420530 2481064 2481064 plaintiff Wake William (legal representative) 760279 760279 Wake, William, of Mauby, administratrix of 0
5420533 2481064 2481064 defendant Kynderby John husbandman 760279 760279 Kynderby, John, of Mauby, husbandman 1
5427498 2483176 2483176 defendant Skupholme William yeoman 760279 760279 Skupholme, William, of Mauby, yeoman 0
5441335 2487326 2487326 plaintiff (illegible) William (legal representative) 760279 760279 _, William, of Mauby, administratrix of 0
5441338 2487326 2487326 defendant Kynyardby John husbandman 760279 760279 Kynyardby, John, of Mauby, husbandman 1
5452572 2490653 2490653 defendant Skipholm William yeoman 760279 760279 Skipholm, William, of Mauby, yeoman 0
5452573 2490653 2490653 defendant Skepholm John laborer 760279 760279 Skepholm, John, of Mauby, laborer 1
5452659 2490679 2490679 defendant Scophelm William yeoman 760279 760279 Scophelm, William, of Mauby, yeoman 0
5452660 2490679 2490679 defendant Scoopholm John laborer 760279 760279 Scoopholm, John, of Mauby, laborer 1
5453205 2490838 2490838 defendant Kynyerdby John husbandman 760279 760279 Kynyerdby, John, of Mauby, husbandman 1
5464148 2494184 2494184 plaintiff Stopholm William yeoman 760279 760279 Stopholm, William, of Mauby, yeoman 0
5464149 2494184 2494184 defendant Kynnyarby John husbandman 760279 760279 Kynnyarby, John, of Mauby, husbandman 0
5475705 2497728 2497728 defendant Kymmyarby John husbandman 760279 760279 Kymmyarby, John, of Mauby, husbandman 0
5618049 2549463 2549463 defendant Shephird William   760279 760279 Shephird, William, of Mauby 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);