names

40 rows where place_id = 609158

✎ 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
3677255 1918933 1918933 plaintiff Leeke John   609158 609158 Leeke, John, of Becclis 0
3677278 1918944 1918944 plaintiff Leke John   609158 609158 Leke, John, of Becclis 0
3696591 1925167 1925167 defendant Stanfeld Richard yeoman 609158 609158 Stanfeld, Richard, of Becclis, yeoman 0
3696792 1925223 1925223 plaintiff Skynner John (legal representative) 609158 609158 Skynner, John, of Becclis, executors of 0
3696795 1925223 1925223 defendant Rangabarowe Alexander currier 609158 609158 Rangabarowe, Alexander, of Becclis, currier 0
3709643 1929325 1929325 plaintiff Rede William, senior merchant 609158 609158 Rede, William, senior, of Becclis, merchant 0
3770149 1948330 1948330 defendant Burnham John chaplain 609158 609158 Burnham, John, of Becclis, chaplain 0
3820860 1964417 1964417 plaintiff Rede William, senior merchant 609158 609158 Rede, William, senior, of Becclis, merchant 0
3858630 1976369 1976369 defendant Denham John (legal representative) 609158 609158 Denham, John, of Becclis, executors of 3
3867996 1979529 1979529 defendant Lynde John (legal representative) 609158 609158 Lynde, John, of Becclis, husbandman, executor of 0
3871313 1980656 1980656 defendant Crysted Roobert fuller 609158 609158 Crysted, Roobert, of Becclis, fuller 1
3886195 1985634 1985634 defendant Grene Agnes widow 609158 609158 Grene, Agnes, of Becclis, widow 0
3949024 2006725 2006725 plaintiff Downyng Thomas draper or merchant 609158 609158 Downyng, Thomas, of Becclis, draper or merchant 0
3970505 2014281 2014281 plaintiff Denney John   609158 609158 Denney, John, of Becclis 0
3971803 2014697 2014697 defendant Bradly Robert tanner 609158 609158 Bradly, Robert, of Becclis, tanner 0
3996975 2023686 2023686 defendant Agas Thomas yeoman 609158 609158 Agas, Thomas, of Becclis, yeoman 0
4008558 2027825 2027825 defendant Cooke John barker 609158 609158 Cooke, John, of Becclis, barker 1
4024814 2033556 2033556 defendant Back Richard yeoman 609158 609158 Back, Richard, of Becclis, yeoman 2
4043886 2040263 2040263 plaintiff Prynte Mathew yeoman 609158 609158 Prynte, Mathew, of Becclis, yeoman 0
4078885 2052746 2052746 defendant Clyfton Thomas miller 609158 609158 Clyfton, Thomas, of Becclis, miller 0
4789305 2292716 2292716 defendant Bery John mercer 609158 609158 Bery, John, of Becclis, mercer 1
4896837 2325669 2325669 plaintiff Falk Walter (legal representative) 609158 609158 Falk, Walter, of Becclis, executor of 0
5066926 2376632 2376632 defendant Baron John yeoman 609158 609158 Baron, John, of Becclis, yeoman 3
5116296 2391196 2391196 plaintiff Olton Thomas (legal representative) 609158 609158 Olton, Thomas, of Becclis, merchant, executors of 0
5116300 2391196 2391196 defendant Laurence William shoemaker 609158 609158 Laurence, William, of Becclis, shoemaker 0
5120042 2392300 2392300 plaintiff Spenser Henry   609158 609158 Spenser, Henry, of Becclis, or of Norwich 0
5215154 2420155 2420155 defendant Puttok Thomas   609158 609158 Puttok, Thomas, of Becclis, servant 0
5222987 2422442 2422442 plaintiff Fraunk John   609158 609158 Fraunk, John, of Becclis 2
5230382 2424502 2424502 defendant Sewale Thomas yeoman 609158 609158 Sewale, Thomas, of Becclis, yeoman 0
5314344 2449310 2449310 plaintiff Burghasch Elizabeth widow 609158 609158 Burghasch, Elizabeth, of Becclis, widow 1
5459930 2492899 2492899 defendant Estgate John   609158 609158 Estgate, John, of Becclis, baker, administrators of 0
5459931 2492899 2492899 defendant Horn Henry weaver 609158 609158 (Horn, Henry, of Becclis, weaver 1
5459932 2492899 2492899 defendant Estgate Margaret widow 609158 609158 Estgate, Margaret, of Becclis, widow 2
5461635 2493418 2493418 defendant Mekilfeld Henry sadler 609158 609158 Mekilfeld, Henry, of Becclis, sadler 2
5471586 2496449 2496449 defendant Estgate John   609158 609158 Estgate, John, of Becclis, baker, administrators of 0
5471587 2496449 2496449 defendant Horn Henry weaver 609158 609158 (Horn, Henry, of Becclis, weaver 1
5471588 2496449 2496449 defendant Estgate Margaret widow 609158 609158 Estgate, Margaret, of Becclis, widow 2
5486835 2500963 2500963 defendant Quynt John butcher 609158 609158 Quynt, John, of Becclis, butcher 1
5520698 2511297 2511297 defendant Moore Thomas laborer 609158 609158 Moore, Thomas, of Becclis, laborer 1
5591209 2532224 2532224 defendant Stanley William gent 609158 609158 Stanley, William, of Becclis, gent 4

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);