names

53 rows where place_id = 598288

✎ 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
3631860 1904774 1904774 defendant Body Robert shoemaker 598288 598288 Body, Robert, of Berkwey, shoemaker 1
3645167 1908896 1908896 defendant Godsane or Godsave Hugh yeoman 598288 598288 Godsane or Godsave, Hugh, of Berkwey, yeoman 0
3645169 1908897 1908897 defendant Godsave Hugh yeoman 598288 598288 Godsave, Hugh, of Berkwey, yeoman 0
3700049 1926248 1926248 defendant Hoye William innholder 598288 598288 Hoye, William, of Berkwey, innholder 0
3700050 1926248 1926248 defendant Bocher Robert butcher 598288 598288 Bocher, Robert, of Berkwey, butcher 1
3743971 1940004 1940004 defendant Gery William gent 598288 598288 Gery, William, of Berkwey, gent 0
3762404 1945883 1945883 defendant Royston William husbandman 598288 598288 Royston, William, of Berkwey, husbandman 0
3782453 1952253 1952253 defendant Webbe Nicholas innholder 598288 598288 Webbe, Nicholas, of Berkwey, innholder 5
3787969 1954031 1954031 plaintiff Serle John   598288 598288 Serle, John, of Berkwey 0
3788754 1954287 1954287 defendant Hager Robert yeoman 598288 598288 Hager, Robert, of Berkwey, yeoman 1
3799037 1957610 1957610 defendant Astell John smith 598288 598288 Astell, John, of Berkwey, smith 0
3821545 1964635 1964635 defendant Webbe Nicholas innholder 598288 598288 Webbe, Nicholas, of Berkwey, innholder 0
3821546 1964635 1964635 defendant Camp Richard husbandman 598288 598288 Camp, Richard, of Berkwey, husbandman 1
3821547 1964635 1964635 defendant Newenham Robert laborer 598288 598288 Newenham, Robert, of Berkwey, laborer 2
3821548 1964635 1964635 defendant Astell John smith 598288 598288 Astell, John, of Berkwey, smith 3
3823513 1965255 1965255 defendant Webbe Nicholas innholder 598288 598288 Webbe, Nicholas, of Berkwey, innholder 0
4588216 2227709 2227709 defendant Reve William   598288 598288 Reve, William, of Berkwey 2
4588220 2227710 2227710 defendant Reve William   598288 598288 Reve, William, of Berkwey 2
4624056 2238501 2238501 defendant Martyn Thomas   598288 598288 Martyn, Thomas, of Berkwey 0
4624058 2238502 2238502 defendant Martyn Thomas   598288 598288 Martyn, Thomas, of Berkwey 0
4624059 2238502 2238502 defendant Payn Thomas shoemaker 598288 598288 together with Payn, Thomas, of Berkwey, shoemaker 1
4640572 2243350 2243350 defendant Rombolt John   598288 598288 Rombolt, John, of Berkwey 1
4668299 2255799 2255799 defendant Reve William hosteler 598288 598288 Reve, William, of Berkwey, hosteler 1
4734637 2275992 2275992 defendant Sexy Thomas chaplain 598288 598288 (Sexy, Thomas, of Berkwey, chaplain 5
4734638 2275992 2275992 defendant Clerk John   598288 598288 Clerk, John, of Berkwey, vicar 6
4738726 2277199 2277199 defendant Royston Peter husbandman 598288 598288 Royston, Peter, of Berkwey, husbandman 2
4738727 2277199 2277199 defendant Reve William hosteller 598288 598288 Reve, William, of Berkwey, hosteller 3
4795890 2294865 2294865 defendant Custaunce John husbandman 598288 598288 Custaunce, John, of Berkwey, husbandman 0
4799839 2296130 2296130 defendant Cook John husbandman 598288 598288 Cook, John, of Berkwey, husbandman 3
4806219 2298152 2298152 defendant Bateman John hostiller 598288 598288 Bateman, John, of Berkwey, hostiller 0
4816309 2301186 2301186 defendant Custaunce John husbandman 598288 598288 Custaunce, John, of Berkwey, husbandman 0
4836169 2307294 2307294 defendant Wode William ostler 598288 598288 Wode, William, of Berkwey, ostler 0
4842407 2309160 2309160 defendant Symond John husbandman 598288 598288 Symond, John, of Berkwey, husbandman 1
4868636 2317164 2317164 defendant Grene William husbandman 598288 598288 Grene, William, of Berkwey, husbandman 0
4868639 2317164 2317164 defendant atte Wode William husbandman 598288 598288 atte Wode, William, of Berkwey, husbandman 3
4868641 2317165 2317165 defendant Grene William husbandman 598288 598288 Grene, William, of Berkwey, husbandman 0
4868644 2317165 2317165 defendant atte Wode William husbandman 598288 598288 atte Wode, William, of Berkwey, husbandman 3
4873384 2318632 2318632 defendant Symond John husbandman 598288 598288 Symond, John, of Berkwey, husbandman 0
4904133 2327904 2327904 defendant Symond John husbandman 598288 598288 Symond, John, of Berkwey, husbandman 1
4913556 2330736 2330736 plaintiff Cock William   598288 598288 Cock, William, of Berkwey 0
4913557 2330736 2330736 defendant Cock William   598288 598288 Cock, William, of Berkwey 0
4924083 2333972 2333972 defendant Grene William husbandman 598288 598288 Grene, William, of Berkwey, husbandman 0
4944432 2340237 2340237 defendant Colbe John ostler 598288 598288 Colbe, John, of Berkwey, ostler 0
4971405 2348375 2348375 defendant Symond John husbandman 598288 598288 Symond, John, of Berkwey, husbandman 1
4979326 2350777 2350777 defendant Andrewe John   598288 598288 Andrewe, John, of Berkwey, notary 0
5112019 2389901 2389901 defendant Lanney Thomas butcher 598288 598288 Lanney, Thomas, of Berkwey, butcher 4
5557646 2522194 2522194 defendant Grevell Robert husbandman 598288 598288 Grevell, Robert, of Berkwey, husbandman 0
5557647 2522194 2522194 defendant Turner Thomas husbandman 598288 598288 Turner, Thomas, of Berkwey, husbandman 1
5557648 2522194 2522194 defendant Skynner John mercer 598288 598288 Skynner, John, of Berkwey, mercer 2
5557649 2522194 2522194 defendant Wylson John carpenter 598288 598288 Wylson, John, of Berkwey, carpenter 3
5573922 2526938 2526938 defendant Holder William butcher 598288 598288 Holder, William, of Berkwey, butcher 0
5573923 2526938 2526938 defendant Grenehill John husbandman 598288 598288 Grenehill, John, of Berkwey, husbandman 1
5610747 2547081 2547081 defendant Dryvere John   598288 598288 Dryvere, John, of Berkwey 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);