names

27 rows where place_id = 587399

✎ 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
3591299 1864906 1864906 defendant Manyngham Thomas dyer 587399 587399 Manyngham, Thomas, of Leyghton Bosard, Beds, dyer 0
3606259 1869624 1869624 defendant Mason John glover 587399 587399 Mason, John, of Leyghton Bosard, Beds, glover 0
3614572 1872207 1872207 defendant Brown John dyer 587399 587399 Brown, John, of Leyghton Bosard, Beds, dyer 0
3615906 1872615 1872615 defendant Malyn Thomas glover 587399 587399 Malyn, Thomas, of Leyghton Bosard, Beds, glover 0
3616518 1872803 1872803 defendant Mason John glover 587399 587399 Mason, John, of Leyghton Bosard, Beds, glover 1
3662617 1914227 1914227 defendant Broun John dyer 587399 587399 Broun, John, of Leyghton Bosard, Beds, dyer 0
4746797 2279564 2279564 defendant Godewyn John chapman 587399 587399 Godewyn, John, of Leyghton Bosard, Beds, chapman 0
4795489 2294741 2294741 defendant Morton John woolman 587399 587399 Morton, John, of Leyghton Bosard, Beds, woolman 1
4824197 2303640 2303640 defendant Coteller John butcher 587399 587399 Coteller, John, of Leyghton Bosard, Beds, butcher 0
4891509 2324080 2324080 defendant North John butcher 587399 587399 North, John, of Leyghton Bosard, Beds, butcher 1
4936263 2337741 2337741 defendant Chaundeler Roger chandler 587399 587399 Chaundeler, Roger, of Leyghton Bosard, Beds, chandler 0
5085602 2382186 2382186 defendant Halcy John mercer 587399 587399 Halcy, John, of Leyghton Bosard, Beds, mercer 0
5285522 2440784 2440784 defendant Southwode Richard yeoman 587399 587399 Southwode, Richard, of Leyghton Bosard, Beds, yeoman 0
5285524 2440785 2440785 defendant Southwode Richard yeoman 587399 587399 Southwode, Richard, of Leyghton Bosard, Beds, yeoman 0
5379720 2469241 2469241 defendant Alegh William yeoman 587399 587399 Alegh, William, of Leyghton Bosard, Beds, yeoman 1
5404188 2476276 2476276 defendant Halsy John mercer 587399 587399 Halsy, John, of Leyghton Bosard, Beds, mercer 0
5404197 2476277 2476277 defendant Halsy John mercer 587399 587399 Halsy, John, of Leyghton Bosard, Beds, mercer 5
5419957 2480885 2480885 defendant Draper (illegible) husbandman 587399 587399 Draper, _, of Leyghton Bosard, Beds, husbandman 0
5481587 2499422 2499422 defendant Hardyng William husbandman 587399 587399 Hardyng, William, of Leyghton Bosard, Beds, husbandman 0
5485125 2500471 2500471 defendant Halsey John chapman 587399 587399 Halsey, John, of Leyghton Bosard, Beds, chapman 3
5487464 2501144 2501144 defendant Reyner William chandler 587399 587399 Reyner, William, of Leyghton Bosard, Beds, chandler 0
5503794 2506103 2506103 defendant Brame or Braine Robert mercer 587399 587399 Brame or Braine, Robert, of Leyghton Bosard, Beds, mercer 2
5506624 2506985 2506985 defendant Manyngham Thomas dyer 587399 587399 Manyngham, Thomas, of Leyghton Bosard, Beds, dyer 0
5514941 2509513 2509513 defendant Smyth Richard husbandman 587399 587399 Smyth, Richard, of Leyghton Bosard, Beds, husbandman 1
5522783 2511953 2511953 defendant Wellys Richard drover 587399 587399 Wellys, Richard, of Leyghton Bosard, Beds, drover 0
5559338 2522697 2522697 defendant Neweman alias Ryott Robert yeoman 587399 587399 Neweman alias Ryott, Robert, of Leyghton Bosard, Beds, yeoman 0
5609715 2537933 2537933 defendant Alegh William yeoman 587399 587399 Alegh, William, of Leyghton Bosard, Beds, yeoman 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);