names

26 rows where place_id = 794804

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4742917 2278438 2278438 defendant Goldsmyth John goldsmith 794804 794804 Goldsmyth, John, of Melton Moubray, Leics, goldsmith 0
4808616 2298860 2298860 defendant Goldesmyth John merchant 794804 794804 Goldesmyth, John, of Melton Moubray, Leics, merchant 0
4937114 2337980 2337980 defendant Goldsmyth John merchant 794804 794804 Goldsmyth, John, of Melton Moubray, Leics, merchant 0
4959733 2344872 2344872 defendant Chaunceler Thomas tailor 794804 794804 Chaunceler, Thomas, of Melton Moubray, Leics, tailor 0
4967901 2347345 2347345 defendant Goldsmyth John merchant 794804 794804 Goldsmyth, John, of Melton Moubray, Leics, merchant 0
4983819 2352089 2352089 defendant Elmonden Thomas fisher 794804 794804 Elmonden, Thomas, of Melton Moubray, Leics, fisher 5
4983826 2352090 2352090 defendant Elmonden Thomas fisher 794804 794804 Elmonden, Thomas, of Melton Moubray, Leics, fisher 5
4994577 2355238 2355238 defendant Goldsmyth John merchant 794804 794804 Goldsmyth, John, of Melton Moubray, Leics, merchant 10
5094835 2384903 2384903 defendant Lee Robert husbandman 794804 794804 Lee, Robert, of Melton Moubray, Leics, husbandman 0
5112118 2389927 2389927 defendant Clay Robert yeoman 794804 794804 Clay, Robert, of Melton Moubray, Leics, yeoman 0
5139615 2398064 2398064 defendant Cley Robert husbandman 794804 794804 Cley, Robert, of Melton Moubray, Leics, husbandman 4
5139621 2398065 2398065 defendant Cley Robert husbandman 794804 794804 Cley, Robert, of Melton Moubray, Leics, husbandman 4
5143075 2399102 2399102 defendant Clay Robert yeoman 794804 794804 Clay, Robert, of Melton Moubray, Leics, yeoman 0
5188411 2412325 2412325 defendant Clay Robert yeoman 794804 794804 Clay, Robert, of Melton Moubray, Leics, yeoman 0
5213271 2419615 2419615 defendant Roule Thomas husbandman 794804 794804 Roule, Thomas, of Melton Moubray, Leics, husbandman 3
5214997 2420109 2420109 defendant Lane William   794804 794804 Lane, William, of Melton Moubray, Leics, court holder 1
5239833 2427226 2427226 defendant Cley Robert yeoman 794804 794804 Cley, Robert, of Melton Moubray, Leics, yeoman 1
5263540 2434346 2434346 defendant Lumbard William cordwainer 794804 794804 Lumbard, William, of Melton Moubray, Leics, cordwainer 1
5275985 2438051 2438051 defendant (illegible) R--- barber 794804 794804 ---, R---, of Melton Moubray, Leics, barber 1
5291445 2442504 2442504 defendant Lenton John yeoman 794804 794804 Lenton, John, of Melton Moubray, Leics, yeoman 1
5291448 2442505 2442505 defendant Lenton John yeoman 794804 794804 Lenton, John, of Melton Moubray, Leics, yeoman 1
5294933 2443510 2443510 defendant Trussell Roger barber 794804 794804 Trussell, Roger, of Melton Moubray, Leics, barber 0
5294940 2443511 2443511 defendant Trussell Roger barber 794804 794804 Trussell, Roger, of Melton Moubray, Leics, barber 0
5632827 2554279 2554279 defendant Straunge Henry ironmonger 794804 794804 Straunge, Henry, of Melton Moubray, Leics, ironmonger 0
5632847 2554282 2554282 defendant Freman Robert spicer 794804 794804 Freman, Robert, of Melton Moubray, Leics, spicer 1
5632894 2554295 2554295 defendant Straunge Henry ironmonger 794804 794804 Straunge, Henry, of Melton Moubray, Leics, ironmonger 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);