names

31 rows where place_id = 763082

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4494073 2198835 2198835 defendant Goos John   763082 763082 Goos, John, of Reylegh 1
4510937 2203874 2203874 defendant Solers Margery   763082 763082 Solers, Margery, of Reylegh 3
4512001 2204193 2204193 defendant Boteler Reginald   763082 763082 Boteler, Reginald, of Reylegh 1
4533366 2210700 2210700 defendant Brook William   763082 763082 Brook, William, of Reylegh 1
4605888 2232955 2232955 defendant Yonge Simon   763082 763082 Yonge, Simon, of Reylegh 2
4606870 2233259 2233259 plaintiff Bartelot John   763082 763082 Bartelot, John, of Reylegh 0
4606871 2233259 2233259 defendant Baryngton John   763082 763082 Baryngton, John, of Reylegh 0
4607055 2233319 2233319 plaintiff Neweman Peter   763082 763082 Neweman, Peter, of Reylegh 2
4610647 2234396 2234396 defendant Taylour John   763082 763082 Taylour, John, of Reylegh 2
4610651 2234396 2234396 defendant Olyver John baker 763082 763082 Olyver, John, of Reylegh, baker 6
4615843 2235948 2235948 defendant Neweman Peter   763082 763082 Neweman, Peter, of Reylegh 0
4617315 2236432 2236432 defendant Aleyn John   763082 763082 Aleyn, John, of Reylegh 0
4631288 2240680 2240680 defendant Neweman Lawrence   763082 763082 Neweman, Lawrence, of Reylegh 1
4652094 2246595 2246595 defendant Yonge Simon   763082 763082 Yonge, Simon, of Reylegh 0
4664307 2250318 2250318 defendant Lynde John weaver 763082 763082 Lynde, John, of Reylegh, weaver 0
4664308 2250318 2250318 defendant Kent John ploughman 763082 763082 Kent, John, of Reylegh, ploughman 1
4675259 2257873 2257873 defendant Ploughgrom Walter laborer 763082 763082 Ploughgrom, Walter, of Reylegh, laborer 2
4738520 2277140 2277140 defendant Parker John shoemaker 763082 763082 Parker, John, of Reylegh, shoemaker 1
4738526 2277141 2277141 defendant Parker John   763082 763082 Parker, John, of Reylegh, shoe maker 1
4805127 2297806 2297806 defendant Okeley William yeoman 763082 763082 Okeley, William, of Reylegh, yeoman 1
4942792 2339717 2339717 plaintiff Fuller John   763082 763082 Fuller, John, of Reylegh 0
4946613 2340937 2340937 defendant Nyghteld John butcher 763082 763082 Nyghteld, John, of Reylegh, butcher 0
4952103 2342597 2342597 defendant Higham John husbandman 763082 763082 Higham, John, of Reylegh, husbandman 0
4968449 2347530 2347530 defendant Ive John   763082 763082 Ive, John, of Reylegh 2
4977478 2350229 2350229 defendant Emery John laborer 763082 763082 Emery, John, of Reylegh, laborer 0
4977479 2350229 2350229 defendant Mereford John husbandman 763082 763082 Mereford, John, of Reylegh, husbandman 1
4997125 2355995 2355995 defendant Fulham Walter chapman 763082 763082 Fulham, Walter, of Reylegh, chapman 0
5071064 2377836 2377836 defendant Welde John draper 763082 763082 Welde, John, of Reylegh, draper 0
5095653 2385151 2385151 defendant Welde John draper 763082 763082 Welde, John, of Reylegh, draper 0
5271589 2436787 2436787 defendant Soler William shoemaker 763082 763082 Soler, William, of Reylegh, shoemaker 0
5337827 2456393 2456393 defendant Sayer William husbandman 763082 763082 Sayer, William, of Reylegh, husbandman 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);