names

47 rows where place_id = 753693

✎ 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
4415222 2169656 2169656 defendant atte Halle Richard   753693 753693 atte Halle, Richard, of Boseworth 0
4423426 2172176 2172176 defendant atte Halle Richard   753693 753693 atte Halle, Richard, of Boseworth 0
4427574 2173459 2173459 plaintiff Scub Richard   753693 753693 Scub, Richard, of Boseworth 0
4427575 2173459 2173459 defendant Hyren Richard in the   753693 753693 Hyren, Richard in the, of Boseworth 0
4434583 2175575 2175575 defendant Saresyn William   753693 753693 Saresyn, William, of Boseworth 0
4434585 2175576 2175576 defendant Saresyn William   753693 753693 Saresyn, William, of Boseworth 0
4440101 2181830 2181830 defendant Bakere Robert   753693 753693 Bakere, Robert, of Boseworth 0
4440103 2181831 2181831 defendant Farndon William   753693 753693 Farndon, William, of Boseworth 0
4457711 2187423 2187423 defendant Pirye William   753693 753693 Pirye, William, of Boseworth 0
4460663 2188394 2188394 defendant Walter Thomas   753693 753693 Walter, Thomas, of Boseworth 0
4460664 2188394 2188394 defendant Daweson John   753693 753693 Daweson, John, of Boseworth 1
4500353 2200733 2200733 plaintiff Hurleman Ralph   753693 753693 Hurleman, Ralph, of Boseworth 0
4501082 2200943 2200943 defendant Bocher Robert   753693 753693 Bocher, Robert, of Boseworth 0
4525016 2208166 2208166 plaintiff Hurlman Ralph   753693 753693 Hurlman, Ralph, of Boseworth 0
4556563 2217988 2217988 plaintiff Hurleman Thomas   753693 753693 Hurleman, Thomas, of Boseworth 0
4559777 2219012 2219012 defendant Hugyn Richard   753693 753693 Hugyn, Richard, of Boseworth 0
4627831 2239630 2239630 defendant Taillour John   753693 753693 Taillour, John, of Boseworth 3
4670547 2256464 2256464 defendant Glover John glover 753693 753693 Glover, John, of Boseworth, glover 1
4671042 2256612 2256612 defendant Ince John gent 753693 753693 Ince, John, of Boseworth, gent 0
4691339 2262814 2262814 defendant Walssh William husbandman 753693 753693 Walssh, William, of Boseworth, husbandman 0
4747089 2279656 2279656 plaintiff Ives John   753693 753693 Ives, John, of Boseworth 0
4781336 2290173 2290173 defendant Tunley John glover 753693 753693 Tunley, John, of Boseworth, glover 1
4789656 2292833 2292833 defendant Milner William miller 753693 753693 Milner, William, of Boseworth, miller 0
4789770 2292869 2292869 defendant Dewy John laborer 753693 753693 Dewy, John, of Boseworth, laborer 4
4789782 2292872 2292872 defendant Smyth Thomas smith 753693 753693 Smyth, Thomas, of Boseworth, smith 0
4790602 2293146 2293146 defendant Ducheman Henry cordwainer 753693 753693 Ducheman, Henry, of Boseworth, cordwainer 1
4812201 2299930 2299930 defendant Grysby John mercer 753693 753693 Grysby, John, of Boseworth, mercer 0
4859571 2314364 2314364 defendant Heelde John smith 753693 753693 Heelde, John, of Boseworth, smith 0
4955968 2343751 2343751 defendant Wodehous Robert yeoman 753693 753693 Wodehous, Robert, of Boseworth, yeoman 1
4955969 2343751 2343751 defendant Assheby John husbandman 753693 753693 Assheby, John, of Boseworth, husbandman 2
4955970 2343751 2343751 defendant Stokes Thomas draper 753693 753693 Stokes, Thomas, of Boseworth, draper 3
5013608 2360823 2360823 defendant Barbour Richard husbandman 753693 753693 Barbour, Richard, of Boseworth, husbandman 0
5067585 2376802 2376802 defendant Bocher Henry husbandman 753693 753693 Bocher, Henry, of Boseworth, husbandman 0
5067586 2376802 2376802 defendant Tayllour Clement husbandman 753693 753693 Tayllour, Clement, of Boseworth, husbandman 1
5077826 2379859 2379859 defendant Freman John baker 753693 753693 Freman, John, of Boseworth, baker 0
5086168 2382350 2382350 defendant Palmer William husbandman 753693 753693 Palmer, William, of Boseworth, husbandman 0
5086169 2382350 2382350 defendant Palmer Thomas husbandman 753693 753693 Palmer, Thomas, of Boseworth, husbandman 1
5111458 2389745 2389745 defendant Baker John baker 753693 753693 Baker, John, of Boseworth, baker 0
5127510 2394524 2394524 defendant Payne Thomas   753693 753693 Payne, Thomas, of Boseworth 1
5146385 2400073 2400073 defendant Payn Thomas butcher 753693 753693 Payn, Thomas, of Boseworth, butcher 1
5217851 2420952 2420952 defendant Payn Thomas butcher 753693 753693 Payn, Thomas, of Boseworth, butcher 1
5217852 2420952 2420952 defendant Raven Alan yeoman 753693 753693 Raven, Alan, of Boseworth, yeoman 2
5217855 2420953 2420953 defendant Chircheman John husbandman 753693 753693 Chircheman, John, of Boseworth, husbandman 0
5217856 2420953 2420953 defendant Shephey John husbandman 753693 753693 Shephey, John, of Boseworth, husbandman 1
5303789 2446129 2446129 defendant Payn Thomas butcher 753693 753693 Payn, Thomas, of Boseworth, butcher 0
5303791 2446130 2446130 defendant Payn Thomas   753693 753693 Payn, Thomas, of Boseworth 0
5307515 2447260 2447260 defendant Dethek Bartholomew gent 753693 753693 Dethek, Bartholomew, of Boseworth, gent 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);