names

66 rows where place_id = 591721

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605347 1869339 1869339 defendant Wade William gent 591721 591721 Wade, William, of Alvetheley, gent 0
3608196 1870220 1870220 defendant Grene Robert butcher 591721 591721 Grene, Robert, of Alvetheley, butcher 3
5201595 2416231 2416231 defendant Huntyng John husbandman 591721 591721 Huntyng, John, of Alvetheley, husbandman 0
5310151 2448068 2448068 defendant Kent Thomas husbandman 591721 591721 Kent, Thomas, of Alvetheley, husbandman 1
5327404 2453267 2453267 defendant Stevens Gilbert husbandman 591721 591721 Stevens, Gilbert, of Alvetheley, husbandman 1
5344571 2458470 2458470 defendant Stevyn Gilbert husbandman 591721 591721 Stevyn, Gilbert, of Alvetheley, husbandman 1
5344574 2458470 2458470 defendant Pepacre John butcher 591721 591721 Pepacre, John, of Alvetheley, butcher 4
5354983 2461629 2461629 defendant Benet Thomas chapman 591721 591721 Benet, Thomas, of Alvetheley, chapman 2
5354984 2461629 2461629 defendant Smyth William tailor 591721 591721 Smyth, William, of Alvetheley, tailor 3
5354985 2461629 2461629 defendant Broun John tailor 591721 591721 Broun, John, of Alvetheley, tailor 4
5354986 2461629 2461629 defendant Scott John   591721 591721 Scott, John, of Alvetheley, surgeon 5
5369030 2465907 2465907 defendant Nyghtynghale William butcher 591721 591721 Nyghtynghale, William, of Alvetheley, butcher 0
5369032 2465908 2465908 defendant Nyghtynghale William butcher 591721 591721 Nyghtynghale, William, of Alvetheley, butcher 0
5372047 2466853 2466853 defendant Dey John butcher 591721 591721 Dey, John, of Alvetheley, butcher 0
5380956 2469610 2469610 defendant Wylde Henry yeoman 591721 591721 Wylde, Henry, of Alvetheley, yeoman 0
5380960 2469611 2469611 defendant Sankyn John husbandman 591721 591721 Sankyn, John, of Alvetheley, husbandman 1
5383082 2470233 2470233 defendant Pert William gent 591721 591721 Pert, William, of Alvetheley, gent 0
5387050 2471364 2471364 defendant Pert William gent 591721 591721 Pert, William, of Alvetheley, gent 0
5387051 2471364 2471364 defendant Sankyn John husbandman 591721 591721 Sankyn, John, of Alvetheley, husbandman 1
5388926 2471893 2471893 defendant Pert William gent 591721 591721 Pert, William, of Alvetheley, gent 10
5391062 2472514 2472514 defendant Jeres Roger husbandman 591721 591721 Jeres, Roger, of Alvetheley, husbandman 0
5391915 2472765 2472765 defendant Spencer John mariner 591721 591721 Spencer, John, of Alvetheley, mariner 1
5394569 2473508 2473508 defendant Pert William gent 591721 591721 Pert, William, of Alvetheley, gent 0
5401644 2475534 2475534 defendant Perte William gent 591721 591721 Perte, William, of Alvetheley, gent 10
5406846 2477023 2477023 defendant Pert William gent 591721 591721 Pert, William, of Alvetheley, gent 0
5411278 2478331 2478331 defendant Pert William gent 591721 591721 Pert, William, of Alvetheley, gent 2
5413932 2479098 2479098 defendant Hampshire John husbandman 591721 591721 Hampshire, John, of Alvetheley, husbandman 0
5413933 2479098 2479098 defendant Ponde William husbandman 591721 591721 Ponde, William, of Alvetheley, husbandman 1
5418123 2480345 2480345 defendant Spencer John mariner 591721 591721 Spencer, John, of Alvetheley, mariner 0
5420002 2480900 2480900 defendant Pert William gent 591721 591721 Pert, William, of Alvetheley, gent 0
5424930 2482422 2482422 defendant Nytyngale William butcher 591721 591721 Nytyngale, William, of Alvetheley, butcher 0
5426140 2482772 2482772 defendant Wylde Henry yeoman 591721 591721 Wylde, Henry, of Alvetheley, yeoman 0
5427272 2483100 2483100 defendant Nightynghale William butcher 591721 591721 Nightynghale, William, of Alvetheley, butcher 0
5435896 2485679 2485679 defendant Spencer John mariner 591721 591721 Spencer, John, of Alvetheley, mariner 0
5435902 2485680 2485680 defendant Spencer John mariner 591721 591721 Spencer, John, of Alvetheley, mariner 0
5438610 2486486 2486486 defendant Pert William gent 591721 591721 Pert, William, of Alvetheley, gent 0
5438612 2486487 2486487 defendant Pert William gent 591721 591721 Pert, William, of Alvetheley, gent 0
5440067 2486933 2486933 defendant Perte William gent 591721 591721 Perte, William, of Alvetheley, gent 1
5445086 2488418 2488418 defendant Nytynghale William butcher 591721 591721 Nytynghale, William, of Alvetheley, butcher 0
5445092 2488420 2488420 defendant Broun John tailor 591721 591721 Broun, John, of Alvetheley, tailor 0
5445093 2488420 2488420 defendant Sawyn John, senior husbandman 591721 591721 Sawyn, John, senior, of Alvetheley, husbandman 1
5449750 2489814 2489814 defendant (illegible) Peter, sen husbandman 591721 591721 _, Peter, sen, of Alvetheley, husbandman 0
5452435 2490604 2490604 defendant Forse Giles husbandman 591721 591721 Forse, Giles, of Alvetheley, husbandman 0
5452506 2490629 2490629 defendant Gervyse John husbandman 591721 591721 Gervyse, John, of Alvetheley, husbandman 0
5453344 2490885 2490885 defendant Clerk William husbandman 591721 591721 Clerk, William, of Alvetheley, husbandman 0
5453345 2490885 2490885 defendant Perte William gent 591721 591721 Perte, William, of Alvetheley, gent 1
5453951 2491072 2491072 defendant Nytyngale William butcher 591721 591721 Nytyngale, William, of Alvetheley, butcher 0
5457749 2492215 2492215 defendant Broun John tailor 591721 591721 Broun, John, of Alvetheley, tailor 0
5457750 2492215 2492215 defendant Sawen John, sen husbandman 591721 591721 Sawen, John, sen, of Alvetheley, husbandman 1
5457754 2492216 2492216 defendant Nytynghale William butcher 591721 591721 Nytynghale, William, of Alvetheley, butcher 0
5464344 2494244 2494244 defendant Gervyse John husbandman 591721 591721 Gervyse, John, of Alvetheley, husbandman 0
5465103 2494467 2494467 defendant Nytyngale William butcher 591721 591721 Nytyngale, William, of Alvetheley, butcher 0
5465271 2494518 2494518 defendant Clerk William husbandman 591721 591721 Clerk, William, of Alvetheley, husbandman 0
5465272 2494518 2494518 defendant Perte William gent 591721 591721 Perte, William, of Alvetheley, gent 1
5474240 2497270 2497270 defendant Jerveys John   591721 591721 Jerveys, John, of Alvetheley 0
5474244 2497272 2497272 defendant Jerveys John husbandman 591721 591721 Jerveys, John, of Alvetheley, husbandman 0
5475930 2497808 2497808 defendant Forsse Giles husbandman 591721 591721 Forsse, Giles, of Alvetheley, husbandman 0
5476945 2498110 2498110 defendant Clerk William husbandman 591721 591721 Clerk, William, of Alvetheley, husbandman 0
5476946 2498110 2498110 defendant Perte William gent 591721 591721 Perte, William, of Alvetheley, gent 1
5488518 2501452 2501452 defendant Clerke William husbandman 591721 591721 Clerke, William, of Alvetheley, husbandman 1
5488520 2501452 2501452 defendant Sawekyn John laborer 591721 591721 Sawekyn, John, of Alvetheley, laborer 3
5494715 2503308 2503308 defendant Nyghtyngale William butcher 591721 591721 Nyghtyngale, William, of Alvetheley, butcher 5
5496178 2503754 2503754 defendant Dowenes Edward husbandman 591721 591721 Dowenes, Edward, of Alvetheley, husbandman 0
5496752 2503949 2503949 defendant Spayne John husbandman 591721 591721 Spayne, John, of Alvetheley, husbandman 4
5503084 2505873 2505873 defendant Nyghtyngale William butcher 591721 591721 Nyghtyngale, William, of Alvetheley, butcher 0
5608509 2537563 2537563 defendant Nytyngale William butcher 591721 591721 Nytyngale, William, of Alvetheley, butcher 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);