names

56 rows where place_id = 598090

✎ 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
3631066 1904540 1904540 defendant Taillour Richard clerk 598090 598090 Taillour, Richard, of Hunston, clerk 0
3644231 1908627 1908627 defendant Hawke William husbandman 598090 598090 Hawke, William, of Hunston, husbandman 1
3653725 1911427 1911427 defendant Britthewe John husbandman 598090 598090 Britthewe, John, of Hunston, husbandman 2
3656743 1912363 1912363 defendant Broun John butcher 598090 598090 Broun, John, of Hunston, butcher 1
3662050 1914064 1914064 defendant Elys Thomas husbandman 598090 598090 Elys, Thomas, of Hunston, husbandman 6
3765290 1946809 1946809 defendant Hawke William husbandman 598090 598090 Hawke, William, of Hunston, husbandman 0
3765291 1946809 1946809 defendant Hawke John laborer 598090 598090 Hawke, John, of Hunston, laborer 1
3774042 1949597 1949597 defendant Brett Robert husbandman 598090 598090 Brett, Robert, of Hunston, husbandman 1
3795187 1956361 1956361 defendant Hawke William husbandman 598090 598090 Hawke, William, of Hunston, husbandman 3
3801850 1958474 1958474 defendant Hawke William husbandman 598090 598090 Hawke, William, of Hunston, husbandman 2
3802217 1958587 1958587 plaintiff Page John yeoman 598090 598090 Page, John, of Hunston, yeoman 0
3880809 1983849 1983849 defendant Cooke Robert butcher 598090 598090 Cooke, Robert, of Hunston, butcher 3
3895445 1988686 1988686 defendant Sowthowse Robert gent 598090 598090 Sowthowse, Robert, of Hunston, gent 0
3898739 1989781 1989781 defendant Foster William laborer 598090 598090 Foster, William, of Hunston, laborer 5
3904036 1991591 1991591 defendant Foster William laborer 598090 598090 Foster, William, of Hunston, laborer 4
3991971 2021889 2021889 defendant Howell Thomas husbandman 598090 598090 Howell, Thomas, of Hunston, husbandman 3
4058337 2045365 2045365 defendant Heylston Thomas waterman 598090 598090 Heylston, Thomas, of Hunston, waterman 1
4109020 2063482 2063482 defendant Baker Arthur yeoman 598090 598090 Baker, Arthur, of Hunston, yeoman 0
4109040 2063487 2063487 defendant Richardson Nicholas yeoman 598090 598090 Richardson, Nicholas, of Hunston, yeoman 1
4258742 2115890 2115890 defendant Gibson Thomas yeoman 598090 598090 Gibson, Thomas, of Hunston, yeoman 0
4258743 2115890 2115890 defendant Gibson John husbandman 598090 598090 Gibson, John, of Hunston, husbandman 1
4258744 2115890 2115890 defendant Locke Robert husbandman 598090 598090 Locke, Robert, of Hunston, husbandman 2
4258745 2115890 2115890 defendant Bullard John husbandman 598090 598090 Bullard, John, of Hunston, husbandman 3
4274797 2121129 2121129 defendant Downer John yeoman 598090 598090 Downer, John, of Hunston, yeoman 0
4335019 2141982 2141982 defendant Spylman Thomas gent 598090 598090 Spylman, Thomas, of Hunston, gent 0
4383313 2159132 2159132 defendant Downer John   598090 598090 Downer, John, of Hunston yeoman 3
4702316 2266133 2266133 defendant Cartere William, sen husbandman 598090 598090 Cartere, William, sen, of Hunston, husbandman 1
4722754 2272433 2272433 defendant Wythard John clerk 598090 598090 Wythard, John, of Hunston, clerk 3
4746030 2279341 2279341 defendant Bradbrugge Thomas gent 598090 598090 Bradbrugge, Thomas, of Hunston, gent 0
4806197 2298143 2298143 defendant Coke John yeoman 598090 598090 Coke, John, of Hunston, yeoman 2
4811710 2299771 2299771 defendant Trous John de husbandman 598090 598090 Trous, John de, of Hunston, husbandman 0
5013564 2360809 2360809 defendant Hawkere Ralph   598090 598090 Hawkere, Ralph, of Hunston, wright 0
5060093 2374585 2374585 defendant Angell John yeoman 598090 598090 Angell, John, of Hunston, yeoman 2
5092633 2384224 2384224 defendant Fontewade Richard husbandman 598090 598090 Fontewade, Richard, of Hunston, husbandman 0
5092634 2384224 2384224 defendant Cachelove William husbandman 598090 598090 Cachelove, William, of Hunston, husbandman 1
5172014 2407529 2407529 defendant Barker John husbandman 598090 598090 Barker, John, of Hunston, husbandman 3
5172015 2407529 2407529 defendant Munnyng John husbandman 598090 598090 Munnyng, John, of Hunston, husbandman 4
5256364 2432114 2432114 defendant Mathewe Richard husbandman 598090 598090 Mathewe, Richard, of Hunston, husbandman 2
5287915 2441481 2441481 defendant Mahewe Richard husbandman 598090 598090 Mahewe, Richard, of Hunston, husbandman 0
5300002 2444964 2444964 defendant Bret Robert husbandman 598090 598090 Bret, Robert, of Hunston, husbandman 0
5314426 2449341 2449341 defendant Mayhewe John husbandman 598090 598090 Mayhewe, John, of Hunston, husbandman 3
5379588 2469203 2469203 defendant Mayhewe Richard husbandman 598090 598090 Mayhewe, Richard, of Hunston, husbandman 0
5379591 2469203 2469203 defendant Mayhewe John husbandman 598090 598090 Mayhewe, John, of Hunston, husbandman 3
5509795 2507898 2507898 defendant Wanton Robert husbandman 598090 598090 Wanton, Robert, of Hunston, husbandman 1
5519863 2511051 2511051 defendant Hawke Thomas carpenter 598090 598090 Hawke, Thomas, of Hunston, carpenter 1
5519864 2511051 2511051 defendant Mosse Robert husbandman 598090 598090 Mosse, Robert, of Hunston, husbandman 2
5522622 2511901 2511901 defendant Fuller John yeoman 598090 598090 Fuller, John, of Hunston, yeoman 1
5559799 2522824 2522824 defendant Broun Thomas husbandman 598090 598090 Broun, Thomas, of Hunston, husbandman 0
5583943 2530053 2530053 defendant Fuller Robert husbandman 598090 598090 Fuller, Robert, of Hunston, husbandman 2
5606068 2536788 2536788 defendant Barnard John husbandman 598090 598090 Barnard, John, of Hunston, husbandman 0
5606069 2536788 2536788 defendant Barnard John   598090 598090 Barnard, John, of Hunston, groom 1
5606070 2536788 2536788 defendant Snellyng John laborer 598090 598090 Snellyng, John, of Hunston, laborer 2
5606071 2536788 2536788 defendant Reynold William laborer 598090 598090 Reynold, William, of Hunston, laborer 3
5606072 2536788 2536788 defendant Elyot Christine spinster 598090 598090 Elyot, Christine, of Hunston, spinster 4
5606073 2536788 2536788 defendant Beatyn Edith spinster 598090 598090 Beatyn, Edith, of Hunston, spinster 5
5606087 2536793 2536793 defendant Broun John butcher 598090 598090 Broun, John, of Hunston, butcher 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);