names

67 rows where place_id = 597346

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628219 1903685 1903685 defendant Cley Thomas husbandman 597346 597346 Cley, Thomas, of Notton, husbandman 0
3628223 1903686 1903686 defendant Cley Thomas husbandman 597346 597346 Cley, Thomas, of Notton, husbandman 2
3694344 1924436 1924436 defendant Bynke William yeoman 597346 597346 Bynke, William, of Notton, yeoman 0
3694354 1924439 1924439 defendant Bynk William yeoman 597346 597346 Bynk, William, of Notton, yeoman 0
3883754 1984837 1984837 defendant Fowler John laborer 597346 597346 Fowler, John, of Notton, laborer 0
3883755 1984837 1984837 defendant Fowler Edward laborer 597346 597346 Fowler, Edward, of Notton, laborer 1
3883756 1984837 1984837 defendant Fowler William laborer 597346 597346 Fowler, William, of Notton, laborer 2
3883757 1984837 1984837 defendant Denys Richard laborer 597346 597346 Denys, Richard, of Notton, laborer 3
3883758 1984837 1984837 defendant Gamson Henry laborer 597346 597346 Gamson, Henry, of Notton, laborer 4
3883759 1984837 1984837 defendant Cowper Christopher laborer 597346 597346 Cowper, Christopher, of Notton, laborer 5
3883760 1984837 1984837 defendant Cowper William laborer 597346 597346 Cowper, William, of Notton, laborer 6
3883761 1984837 1984837 defendant Wynter Henry laborer 597346 597346 Wynter, Henry, of Notton, laborer 7
3883762 1984837 1984837 defendant Drowry William laborer 597346 597346 Drowry, William, of Notton, laborer 8
3883763 1984837 1984837 defendant Dover William laborer 597346 597346 Dover, William, of Notton, laborer 9
3889404 1986688 1986688 defendant Notyngham John yeoman 597346 597346 Notyngham, John, of Notton, yeoman 1
3976484 2016352 2016352 defendant Foster Richard husbandman 597346 597346 Foster, Richard, of Notton, husbandman 1
4089750 2056631 2056631 defendant Denton Richard yeoman 597346 597346 Denton, Richard, of Notton, yeoman 1
4095326 2058651 2058651 defendant Houghton Richard yeoman 597346 597346 Houghton, Richard, of Notton, yeoman 0
4095327 2058651 2058651 defendant Parker George yeoman 597346 597346 Parker, George, of Notton, yeoman 1
4098462 2059777 2059777 defendant Denton Richard yeoman 597346 597346 Denton, Richard, of Notton, yeoman 2
4107641 2063013 2063013 defendant Denton Richard husbandman 597346 597346 Denton, Richard, of Notton, husbandman 1
4123922 2068855 2068855 defendant Brookes William clerk 597346 597346 Brookes, William, of Notton, clerk 0
4141028 2075021 2075021 defendant Shawe Richard husbandman 597346 597346 (Shawe, Richard, of Notton, husbandman 1
4146550 2076944 2076944 defendant Denton Richard yeoman 597346 597346 Denton, Richard, of Notton, yeoman 0
4150629 2078356 2078356 defendant Denton Richard yeoman 597346 597346 Denton, Richard, of Notton, yeoman 0
4166128 2083661 2083661 defendant Fyxbye Christopher husbandman 597346 597346 Fyxbye, Christopher, of Notton, husbandman 0
4170393 2085137 2085137 defendant Shawe Richard husbandman 597346 597346 Shawe, Richard, of Notton, husbandman 2
4171004 2085341 2085341 defendant Scaberte or Scawberte Robert pointer 597346 597346 Scaberte or Scawberte, Robert, of Notton, or of Hunslette, pointer 0
4343674 2145066 2145066 defendant Foster John husbandman 597346 597346 Foster, John, of Notton, husbandman 0
4390288 2161374 2161374 defendant Scawbert or Stawbert Robert yeoman 597346 597346 Scawbert or Stawbert, Robert, of Notton, yeoman 0
4394831 2162859 2162859 defendant Foster John husbandman 597346 597346 Foster, John, of Notton, husbandman 0
4486832 2196597 2196597 defendant Couper William   597346 597346 Couper, William, of Notton, son of Hugh Couper 1
4488817 2197218 2197218 defendant Prior Robert   597346 597346 Prior, Robert, of Notton 0
4494891 2199088 2199088 defendant Moorgate Robert   597346 597346 Moorgate, Robert, of Notton 2
4530413 2209804 2209804 defendant Hyde Robert   597346 597346 Hyde, Robert, of Notton 0
4561587 2219559 2219559 defendant Marston Robert   597346 597346 Marston, Robert, of Notton 0
4706828 2267515 2267515 defendant Trewelove Simon husbandman 597346 597346 Trewelove, Simon, of Notton, husbandman 0
4706829 2267515 2267515 defendant Trewelove John husbandman 597346 597346 Trewelove, John, of Notton, husbandman 1
4720722 2271812 2271812 defendant Lightolleres Ralph yeoman 597346 597346 Lightolleres, Ralph, of Notton, yeoman 1
4817124 2301448 2301448 defendant Skonle Robert laborer 597346 597346 Skonle, Robert, of Notton, laborer 8
4836237 2307313 2307313 defendant Baldewyn Thomas husbandman 597346 597346 Baldewyn, Thomas, of Notton, husbandman 2
4854242 2312739 2312739 defendant Forster John, sen husbandman 597346 597346 Forster, John, sen, of Notton, husbandman 0
4854243 2312739 2312739 defendant Thawell William husbandman 597346 597346 Thawell, William, of Notton, husbandman 1
4854244 2312739 2312739 defendant Wodward William husbandman 597346 597346 Wodward, William, of Notton, husbandman 2
4854245 2312739 2312739 defendant Smyth John husbandman 597346 597346 Smyth, John, of Notton, husbandman 3
4854379 2312769 2312769 defendant Sparke Thomas husbandman 597346 597346 Sparke, Thomas, of Notton, husbandman 1
5005791 2358592 2358592 defendant Horne John husbandman 597346 597346 Horne, John, of Notton, husbandman 0
5084530 2381885 2381885 defendant Langeley William yeoman 597346 597346 Langeley, William, of Notton, yeoman 3
5129667 2395164 2395164 defendant Forstar John husbandman 597346 597346 Forstar, John, of Notton, husbandman 5
5191803 2413337 2413337 defendant Forstar John husbandman 597346 597346 Forstar, John, of Notton, husbandman 5
5269020 2436041 2436041 defendant Benkes Henry yeoman 597346 597346 Benkes, Henry, of Notton, yeoman 1
5269030 2436043 2436043 defendant Beukes (illegible) yeoman 597346 597346 Beukes, ----, of Notton, yeoman 1
5296048 2443836 2443836 defendant Fygby William yeoman 597346 597346 Fygby, William, of Notton, yeoman 0
5351437 2460549 2460549 defendant Obrome William laborer 597346 597346 Obrome, William, of Notton, laborer 1
5351438 2460549 2460549 defendant Sparke William laborer 597346 597346 Sparke, William, of Notton, laborer 2
5351439 2460549 2460549 defendant Benkes Thomas yeoman 597346 597346 Benkes, Thomas, of Notton, yeoman 3
5363679 2464294 2464294 defendant Benkes Thomas yeoman 597346 597346 Benkes, Thomas, of Notton, yeoman 0
5363680 2464294 2464294 defendant Benkes Richard yeoman 597346 597346 Benkes, Richard, of Notton, yeoman 1
5363681 2464294 2464294 defendant Benkes Robert yeoman 597346 597346 Benkes, Robert, of Notton, yeoman 2
5363682 2464294 2464294 defendant Gille John laborer 597346 597346 Gille, John, of Notton, laborer 3
5363683 2464294 2464294 defendant Hoton Henry laborer 597346 597346 Hoton, Henry, of Notton, laborer 4
5363684 2464294 2464294 defendant Forster Thomas laborer 597346 597346 Forster, Thomas, of Notton, laborer 5
5467219 2495140 2495140 defendant Trowe William laborer 597346 597346 Trowe, William, of Notton, laborer 2
5476165 2497876 2497876 defendant Gylle William yeoman 597346 597346 Gylle, William, of Notton, yeoman 0
5487356 2501113 2501113 defendant Pynnyng William husbandman 597346 597346 Pynnyng, William, of Notton, husbandman 10
5509569 2507828 2507828 defendant Wylbore William husbandman 597346 597346 Wylbore, William, of Notton, husbandman 2
5509574 2507829 2507829 defendant Wylbore William husbandman 597346 597346 Wylbore, William, of Notton, husbandman 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);