names

63 rows where place_id = 595064

✎ 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
3618721 1873477 1873477 plaintiff Palmer Henry   595064 595064 Palmer, Henry, of Gryston 1
3618724 1873478 1873478 plaintiff Palmer Henry   595064 595064 Palmer, Henry, of Gryston 1
3618963 1873542 1873542 plaintiff Palmer Henry   595064 595064 Palmer, Henry, of Gryston 1
3637340 1906483 1906483 defendant Colyn Thomas (legal representative) 595064 595064 Colyn, Thomas, of Gryston, husbandman, executor of 0
3814896 1962575 1962575 defendant Dunthorn John, senior husbandman 595064 595064 Dunthorn, John, senior, of Gryston, husbandman 0
3815065 1962633 1962633 defendant Walter John husbandman 595064 595064 Walter, John, of Gryston, husbandman 0
3815066 1962633 1962633 defendant More James husbandman 595064 595064 More, James, of Gryston, husbandman 1
3830922 1967556 1967556 plaintiff Gewell John   595064 595064 Gewell, John, of Gryston 0
3830924 1967556 1967556 defendant Palmer Henry husbandman 595064 595064 Palmer, Henry, of Gryston, husbandman 1
3835330 1968989 1968989 defendant Pyrry John husbandman 595064 595064 Pyrry, John, of Gryston, husbandman 1
3846482 1972453 1972453 defendant Brond George gent 595064 595064 Brond, George, of Gryston, gent 1
3869420 1980013 1980013 defendant Bradenham alias Aldwyn John yeoman 595064 595064 Bradenham alias Aldwyn, John, of Gryston, yeoman 0
3869422 1980014 1980014 defendant Bradenham alias Aldwyn William singleman 595064 595064 Bradenham alias Aldwyn, William, of Gryston, singleman 0
3911314 1994100 1994100 defendant Brond George gent 595064 595064 Brond, George, of Gryston, gent 0
3911316 1994101 1994101 defendant Bronde George gent 595064 595064 Bronde, George, of Gryston, gent 0
3938205 2003115 2003115 defendant Wyllyamson Robert yeoman 595064 595064 Wyllyamson, Robert, of Gryston, yeoman 0
3949185 2006783 2006783 defendant More James yeoman 595064 595064 More, James, of Gryston, yeoman 0
3960168 2010658 2010658 defendant More James yeoman 595064 595064 More, James, of Gryston, yeoman 0
3961952 2011277 2011277 plaintiff Walter Hugh yeoman 595064 595064 Walter, Hugh, of Gryston, yeoman 0
3961954 2011278 2011278 plaintiff Walter Hugh yeoman 595064 595064 Walter, Hugh, of Gryston, yeoman 0
3961963 2011282 2011282 plaintiff Walter John (legal representative) 595064 595064 Walter, John, of Gryston, yeoman, executor of 0
3961967 2011283 2011283 plaintiff Walter John (legal representative) 595064 595064 Walter, John, of Gryston, yeoman, executor of 0
3963897 2011979 2011979 defendant Browne Robert husbandman 595064 595064 Browne, Robert, of Gryston, husbandman 0
3972334 2014893 2014893 defendant Wyllyamson Robert tailor 595064 595064 Wyllyamson, Robert, of Gryston, tailor 0
3978788 2017159 2017159 defendant Dounthorne William yeoman 595064 595064 Dounthorne, William, of Gryston, yeoman 0
3985744 2019663 2019663 plaintiff Walter Hugh   595064 595064 Walter, Hugh, of Gryston 0
3997288 2023802 2023802 plaintiff Dunthorne William yeoman 595064 595064 Dunthorne, William, of Gryston, yeoman 0
4009234 2028069 2028069 plaintiff Mynnes Peter   595064 595064 Mynnes, Peter, of Gryston 0
4028951 2034999 2034999 plaintiff Cretoft Robert gent 595064 595064 Cretoft, Robert, of Gryston, gent 0
4126817 2069881 2069881 defendant Waller Thomas husbandman 595064 595064 Waller, Thomas, of Gryston, husbandman 1
4150180 2078197 2078197 defendant Waller Thomas husbandman 595064 595064 Waller, Thomas, of Gryston, husbandman 1
4275279 2121289 2121289 defendant Burrowe Geoffrey gent 595064 595064 Burrowe, Geoffrey, of Gryston, or of Furnivals Inn, Holborne, Middx, gent 2
4311717 2134239 2134239 defendant Dunthorne Henry yeoman 595064 595064 Dunthorne, Henry, of Gryston, yeoman 2
4332758 2141238 2141238 defendant Burrowe Geoffrey gent 595064 595064 Burrowe, Geoffrey, of Gryston, gent 2
4448864 2184584 2184584 defendant Fychet William   595064 595064 Fychet, William, of Gryston 2
4555052 2217507 2217507 defendant Herre Robert   595064 595064 Herre, Robert, of Gryston 0
4581745 2225731 2225731 defendant Randolf John   595064 595064 Randolf, John, of Gryston 0
4581861 2225772 2225772 defendant Randolf John   595064 595064 Randolf, John, of Gryston 0
4619582 2237116 2237116 defendant Broun Richard   595064 595064 Broun, Richard, of Gryston 1
4632268 2240979 2240979 defendant Cok William   595064 595064 Cok, William, of Gryston 0
4776423 2288621 2288621 defendant Harre William yeoman 595064 595064 Harre, William, of Gryston, yeoman 0
4776425 2288621 2288621 defendant Marchaunt Thomas yeoman 595064 595064 Marchaunt, Thomas, of Gryston, yeoman 2
4776426 2288621 2288621 defendant Randolf Robert yeoman 595064 595064 Randolf, Robert, of Gryston, yeoman 3
4810006 2299287 2299287 plaintiff Elyngham Thomas   595064 595064 Elyngham, Thomas, of Gryston 0
4812608 2300059 2300059 defendant Busshop Robert yeoman 595064 595064 Busshop, Robert, of Gryston, yeoman 4
5185075 2411374 2411374 defendant Harre John yeoman 595064 595064 Harre, John, of Gryston, yeoman 2
5216445 2420539 2420539 defendant Harre John husbandman 595064 595064 Harre, John, of Gryston, husbandman 0
5233874 2425493 2425493 defendant Bettys John husbandman 595064 595064 Bettys, John, of Gryston, husbandman 0
5233875 2425493 2425493 defendant Bysshop John husbandman 595064 595064 Bysshop, John, of Gryston, husbandman 1
5233876 2425493 2425493 defendant Bettys William husbandman 595064 595064 Bettys, William, of Gryston, husbandman 2
5233877 2425493 2425493 defendant Cappe Thomas husbandman 595064 595064 Cappe, Thomas, of Gryston, husbandman 3
5286906 2441172 2441172 defendant Harre John yeoman 595064 595064 Harre, John, of Gryston, yeoman 2
5305295 2446588 2446588 defendant Harre John husbandman 595064 595064 Harre, John, of Gryston, husbandman 0
5335899 2455805 2455805 defendant Harre John yeoman 595064 595064 Harre, John, of Gryston, yeoman 0
5351994 2460727 2460727 defendant Plowryght Andrew husbandman 595064 595064 Plowryght, Andrew, of Gryston, husbandman 0
5351995 2460727 2460727 defendant Reynold John laborer 595064 595064 Reynold, John, of Gryston, laborer 1
5486954 2500994 2500994 defendant Harre John yeoman 595064 595064 Harre, John, of Gryston, yeoman 2
5498815 2504586 2504586 plaintiff Palmer Henry   595064 595064 Palmer, Henry, of Gryston 0
5499565 2504817 2504817 defendant Marchall Robert husbandman 595064 595064 Marchall, Robert, of Gryston, husbandman 1
5513468 2509059 2509059 plaintiff Palmer Henry   595064 595064 Palmer, Henry, of Gryston 0
5535169 2515527 2515527 plaintiff Bettys John   595064 595064 Bettys, John, of Gryston 0
5535170 2515527 2515527 defendant Busshope alias Clement John (legal representative) 595064 595064 Busshope alias Clement, John, of Gryston, husbandman, executor of 0
5621289 2550547 2550547 defendant Jurdon Richard   595064 595064 Jurdon, Richard, of Gryston 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);