names

42 rows where place_id = 587793

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592460 1865256 1865256 defendant Corbold John husbandman 587793 587793 Corbold, John, of Bedfeld, husbandman 2
3603069 1868626 1868626 defendant Corbold John husbandman 587793 587793 Corbold, John, of Bedfeld, husbandman 2
3606547 1869719 1869719 defendant Corbald Richard butcher 587793 587793 Corbald, Richard, of Bedfeld, butcher 2
3619083 1873570 1873570 defendant Elys John husbandman 587793 587793 Elys, John, of Bedfeld, husbandman 0
3783140 1952483 1952483 defendant Cracy William pointmaker 587793 587793 Cracy, William, of Bedfeld, pointmaker 0
3793882 1955954 1955954 defendant Cressey William   587793 587793 Cressey, William, of Bedfeld, point maker 0
3799708 1957828 1957828 defendant Cray William   587793 587793 Cray, William, of Bedfeld, point maker 0
3995119 2023003 2023003 plaintiff Corbolde Robert yeoman 587793 587793 Corbolde, Robert, of Bedfeld, yeoman 0
4325674 2138965 2138965 defendant Reade John   587793 587793 Reade, John, of Bedfeld brick burner 1
4766127 2285396 2285396 defendant Wyth William yeoman 587793 587793 Wyth, William, of Bedfeld, yeoman 0
4775649 2288379 2288379 defendant Shanke Alexander yeoman 587793 587793 Shanke, Alexander, of Bedfeld, yeoman 1
5028055 2365084 2365084 plaintiff Mey William   587793 587793 Mey, William, of Bedfeld 0
5069834 2377472 2377472 defendant Cole John laborer 587793 587793 Cole, John, of Bedfeld, laborer 1
5069835 2377472 2377472 defendant Page John carpenter 587793 587793 Page, John, of Bedfeld, carpenter 2
5135070 2396754 2396754 defendant Rede William husbandman 587793 587793 Rede, William, of Bedfeld, husbandman 0
5155168 2402659 2402659 defendant Rede William husbandman 587793 587793 Rede, William, of Bedfeld, husbandman 0
5171903 2407497 2407497 defendant Rede William husbandman 587793 587793 Rede, William, of Bedfeld, husbandman 0
5181470 2410319 2410319 defendant Folcard William husbandman 587793 587793 Folcard, William, of Bedfeld, husbandman 1
5225165 2423031 2423031 defendant Wolfe Ralph yeoman 587793 587793 Wolfe, Ralph, of Bedfeld, yeoman 4
5251499 2430571 2430571 defendant Corbold John husbandman 587793 587793 Corbold, John, of Bedfeld, husbandman 1
5263940 2434481 2434481 defendant Corbold John husbandman 587793 587793 Corbold, John, of Bedfeld, husbandman 1
5290440 2442209 2442209 defendant Gerard Richard clerk 587793 587793 Gerard, Richard, of Bedfeld, clerk 0
5351787 2460661 2460661 defendant Wulffe Ralph husbandman 587793 587793 Wulffe, Ralph, of Bedfeld, husbandman 0
5351788 2460661 2460661 defendant Wulffe William husbandman 587793 587793 Wulffe, William, of Bedfeld, husbandman 1
5386471 2471202 2471202 defendant Irlond Robert husbandman 587793 587793 Irlond, Robert, of Bedfeld, husbandman 3
5398761 2474711 2474711 defendant Irlond Robert husbandman 587793 587793 Irlond, Robert, of Bedfeld, husbandman 3
5398766 2474712 2474712 defendant Irlond Robert husbandman 587793 587793 Irlond, Robert, of Bedfeld, husbandman 3
5457229 2492061 2492061 plaintiff Crane Philip   587793 587793 Crane, Philip, of Bedfeld 0
5469080 2495680 2495680 plaintiff Crane Philip   587793 587793 Crane, Philip, of Bedfeld 0
5480251 2499074 2499074 plaintiff Crane or Grave Philip   587793 587793 Crane or Grave, Philip, of Bedfeld 0
5482770 2499792 2499792 defendant Corbald Robert husbandman 587793 587793 Corbald, Robert, of Bedfeld, husbandman 1
5482771 2499792 2499792 defendant Corbald John husbandman 587793 587793 Corbald, John, of Bedfeld, husbandman 2
5498561 2504513 2504513 defendant Rosyngton John husbandman 587793 587793 Rosyngton, John, of Bedfeld, husbandman 0
5523619 2512212 2512212 defendant Folkard William husbandman 587793 587793 Folkard, William, of Bedfeld, husbandman 0
5528828 2513537 2513537 defendant Corbold John gent 587793 587793 Corbold, John, of Bedfeld, gent 3
5555640 2521642 2521642 defendant Fuller Thomas husbandman 587793 587793 Fuller, Thomas, of Bedfeld, husbandman 0
5555644 2521643 2521643 defendant Folcard Nicholas laborer 587793 587793 Folcard, Nicholas, of Bedfeld, laborer 0
5566832 2524895 2524895 plaintiff Crane Philip   587793 587793 Crane, Philip, of Bedfeld 0
5572219 2526427 2526427 plaintiff Mey Thomas   587793 587793 Mey, Thomas, of Bedfeld 0
5572220 2526427 2526427 defendant Folkard William, senior husbandman 587793 587793 Folkard, William, senior, of Bedfeld, husbandman 0
5582854 2529705 2529705 defendant Smyth James clerk 587793 587793 Smyth, James, of Bedfeld, clerk 0
5605329 2536544 2536544 defendant Smyth James clerk 587793 587793 Smyth, James, of Bedfeld, clerk 2

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);