names

25 rows where place_id = 633286

✎ 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
3811809 1961594 1961594 defendant Knyght Robert laborer 633286 633286 Knyght, Robert, of Attelburgh, laborer 1
4432082 2174816 2174816 plaintiff Lorymer Nicholas   633286 633286 Lorymer, Nicholas, of Attelburgh 1
4473318 2192314 2192314 defendant Padgrys John   633286 633286 Padgrys, John, of Attelburgh 0
4473323 2192316 2192316 defendant Galle William   633286 633286 (Galle, William, of Attelburgh 1
4555479 2217647 2217647 defendant Wynter John   633286 633286 Wynter, John, of Attelburgh 6
4555587 2217676 2217676 defendant Lyteproud Robert   633286 633286 Lyteproud, Robert, of Attelburgh 0
4555588 2217676 2217676 defendant Veske Richard   633286 633286 Veske, Richard, of Attelburgh 1
4555589 2217676 2217676 defendant atte Hill Robert   633286 633286 atte Hill, Robert, of Attelburgh 2
4626805 2239325 2239325 defendant Burton William   633286 633286 Burton, William, of Attelburgh 3
4626806 2239325 2239325 defendant Karr Richard   633286 633286 Karr, Richard, of Attelburgh 4
4626807 2239325 2239325 defendant Deene John   633286 633286 Deene, John, of Attelburgh 5
4626809 2239325 2239325 defendant Galle Thomas   633286 633286 Galle, Thomas, of Attelburgh 7
4691318 2262806 2262806 defendant Raynold William   633286 633286 Raynold, William, of Attelburgh, bailiff 1
4710780 2268728 2268728 plaintiff Reynold William   633286 633286 Reynold, William, of Attelburgh 0
4720325 2271697 2271697 defendant Reynold William   633286 633286 Reynold, William, of Attelburgh 4
4742459 2278295 2278295 defendant Reginald William gent 633286 633286 Reginald, William, of Attelburgh, gent 0
4742460 2278295 2278295 defendant Reginald Reginald   633286 633286 Reginald, Reginald, of Attelburgh, gent, son & heir of William 1
4754490 2281784 2281784 defendant Reynoldes Richard husbandman 633286 633286 Reynoldes, Richard, of Attelburgh, husbandman 2
4754492 2281784 2281784 defendant Pytcooke Thomas   633286 633286 Pytcooke, Thomas, of Attelburgh, wright 4
4961992 2345544 2345544 defendant Baxter Bartholomew husbandman 633286 633286 Baxter, Bartholomew, of Attelburgh, husbandman 0
5002571 2357665 2357665 defendant Symond John chapman 633286 633286 Symond, John, of Attelburgh, chapman 0
5026956 2364755 2364755 defendant Colyn Roger yeoman 633286 633286 Colyn, Roger, of Attelburgh, yeoman 0
5208811 2418303 2418303 defendant Radclyff John   633286 633286 Radclyff, John, of Attelburgh, Norfolk esq 0
5241827 2427810 2427810 defendant Faireclowe Thomas clerk 633286 633286 Faireclowe, Thomas, of Attelburgh, clerk 0
5628178 2552774 2552774 defendant Regnaldyn William husbandman 633286 633286 Regnaldyn, William, of Attelburgh, husbandman 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);