names

37 rows where place_id = 591146

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603482 1868755 1868755 defendant Wilkynson Robert yeoman 591146 591146 (Wilkynson, Robert, of North Luffenham, yeoman 1
3685489 1921614 1921614 defendant Goodman Thomas husbandman 591146 591146 Goodman, Thomas, of North Luffenham, husbandman 2
3700528 1926407 1926407 defendant Goodman Thomas husbandman 591146 591146 Goodman, Thomas, of North Luffenham, husbandman 2
3719889 1932491 1932491 defendant Wade Simon husbandman 591146 591146 Wade, Simon, of North Luffenham, husbandman 0
3811141 1961380 1961380 defendant Brygis William miller 591146 591146 Brygis, William, of North Luffenham, miller 3
4181881 2089144 2089144 defendant Wymarke Edward gent 591146 591146 Wymarke, Edward, of North Luffenham, gent 0
4215332 2100859 2100859 defendant Hunt Daniel yeoman 591146 591146 Hunt, Daniel, of North Luffenham, yeoman 0
4264962 2117916 2117916 defendant Hunt Daniel yeoman 591146 591146 Hunt, Daniel, of North Luffenham, yeoman 0
4335721 2142225 2142225 defendant Goodman Simon yeoman 591146 591146 Goodman, Simon, of North Luffenham, yeoman 0
4383028 2159037 2159037 defendant Turney John yeoman 591146 591146 Turney, John, of North Luffenham, yeoman 0
4431907 2174756 2174756 defendant Northburgh Roger de   591146 591146 Northburgh, Roger de, of North Luffenham, parson 0
4463335 2189225 2189225 defendant Waytestathe William   591146 591146 Waytestathe, William, of North Luffenham 0
4465487 2189874 2189874 defendant White William   591146 591146 White, William, of North Luffenham, parson 0
4516945 2205705 2205705 plaintiff Cotyngham Andrew de   591146 591146 Cotyngham, Andrew de, of North Luffenham 0
4555155 2217546 2217546 defendant Michel Alexander   591146 591146 Michel, Alexander, of North Luffenham 0
4573680 2223283 2223283 plaintiff Basset Nicholas   591146 591146 Basset, Nicholas, of North Luffenham 0
4573681 2223283 2223283 defendant Whytlych Robert   591146 591146 Whytlych, Robert, of North Luffenham 0
4855636 2313131 2313131 defendant Palmer James gent 591146 591146 Palmer, James, of North Luffenham, gent 0
4855637 2313131 2313131 defendant Harsden John husbandman 591146 591146 Harsden, John, of North Luffenham, husbandman 1
4888830 2323296 2323296 defendant Spraye Richard yeoman 591146 591146 Spraye, Richard, of North Luffenham, yeoman 0
4934351 2337134 2337134 defendant Palmer John gent 591146 591146 Palmer, John, of North Luffenham, gent 0
4934352 2337134 2337134 defendant Kendale William yeoman 591146 591146 Kendale, William, of North Luffenham, yeoman 1
4934353 2337134 2337134 defendant Basset John gent 591146 591146 Basset, John, of North Luffenham, gent 2
4959606 2344832 2344832 defendant Basset John gent 591146 591146 Basset, John, of North Luffenham, gent 1
4986208 2352802 2352802 defendant Palmer James gent 591146 591146 Palmer, James, of North Luffenham, gent 0
4986209 2352802 2352802 defendant Basset John gent 591146 591146 Basset, John, of North Luffenham, gent 1
4991400 2354312 2354312 defendant Godwyn John husbandman 591146 591146 Godwyn, John, of North Luffenham, husbandman 0
5038716 2368227 2368227 defendant Basset Robert husbandman 591146 591146 Basset, Robert, of North Luffenham, husbandman 1
5038717 2368227 2368227 defendant Godewyn John husbandman 591146 591146 Godewyn, John, of North Luffenham, husbandman 2
5079860 2380454 2380454 defendant Skeffyngton John courser 591146 591146 Skeffyngton, John, of North Luffenham, courser 0
5236760 2426336 2426336 defendant Greneham William esq 591146 591146 Greneham, William, of North Luffenham, esq 2
5303223 2445958 2445958 plaintiff Godeman James   591146 591146 Godeman, James, of North Luffenham 0
5482068 2499568 2499568 defendant Beauchawe Thomas yeoman 591146 591146 Beauchawe, Thomas, of North Luffenham, yeoman 0
5484779 2500371 2500371 defendant Breys Richard husbandman 591146 591146 Breys, Richard, of North Luffenham, husbandman 0
5581136 2529168 2529168 defendant Taillour James shoemaker 591146 591146 Taillour, James, of North Luffenham, shoemaker 0
5620310 2550209 2550209 plaintiff Russell John   591146 591146 Russell, John, of North Luffenham 0
5620311 2550209 2550209 defendant Ouen William carpenter 591146 591146 Ouen, William, of North Luffenham, carpenter 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);