names

54 rows where place_id = 595788

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621896 1874392 1874392 plaintiff Gayton Thomas   595788 595788 (Gayton, Thomas, of Magna Ryburgh 1
3631509 1904670 1904670 defendant Gyles John husbandman 595788 595788 Gyles, John, of Magna Ryburgh, husbandman 0
3724231 1933866 1933866 defendant Sheryngham William butcher 595788 595788 Sheryngham, William, of Magna Ryburgh, butcher 0
3734939 1937164 1937164 defendant Sheryngham William butcher 595788 595788 Sheryngham, William, of Magna Ryburgh, butcher 0
3762977 1946050 1946050 defendant Sheryngham William butcher 595788 595788 Sheryngham, William, of Magna Ryburgh, butcher 3
3767557 1947489 1947489 defendant Barnard George chaplain 595788 595788 Barnard, George, of Magna Ryburgh, chaplain 0
3769020 1947960 1947960 defendant Barnard George chaplain 595788 595788 Barnard, George, of Magna Ryburgh, chaplain 0
3787759 1953963 1953963 defendant Pyke JKohn husbandman 595788 595788 Pyke, JKohn, of Magna Ryburgh, husbandman 0
3803965 1959156 1959156 defendant Pyke John husbandman 595788 595788 Pyke, John, of Magna Ryburgh, husbandman 0
3815122 1962648 1962648 defendant Sheryngham Anne widow 595788 595788 Sheryngham, Anne, of Magna Ryburgh, widow 5
3887121 1985957 1985957 defendant Falkys Henry blacksmith 595788 595788 Falkys, Henry, of Magna Ryburgh, blacksmith 0
3887123 1985957 1985957 defendant Parson Ralph husbandman 595788 595788 Parson, Ralph, of Magna Ryburgh, husbandman 2
3893959 1988203 1988203 defendant Cooke William husbandman 595788 595788 Cooke, William, of Magna Ryburgh, husbandman 0
3952006 2007765 2007765 defendant Harvy Ellen widow 595788 595788 Harvy, Ellen, of Magna Ryburgh, widow 0
3952448 2007925 2007925 defendant Andrewe William gent 595788 595788 Andrewe, William, of Magna Ryburgh, gent 0
4881647 2321160 2321160 defendant Gardener Simon butcher 595788 595788 Gardener, Simon, of Magna Ryburgh, butcher 0
4882920 2321578 2321578 plaintiff Oseyll John yeoman 595788 595788 Oseyll, John, of Magna Ryburgh, yeoman 0
4882921 2321578 2321578 plaintiff Pers Roger husbandman 595788 595788 Pers, Roger, of Magna Ryburgh, husbandman 1
4901154 2326978 2326978 defendant Porter Thomas fuller 595788 595788 Porter, Thomas, of Magna Ryburgh, fuller 3
4901198 2326986 2326986 defendant Cellynys John husbandman 595788 595788 Cellynys, John, of Magna Ryburgh, husbandman 4
4905053 2328189 2328189 defendant Prat Robert husbandman 595788 595788 Prat, Robert, of Magna Ryburgh, husbandman 1
4959129 2344699 2344699 defendant Tryndell Alexander yeoman 595788 595788 Tryndell, Alexander, of Magna Ryburgh, yeoman 2
4963683 2346048 2346048 defendant Oysell John husbandman 595788 595788 Oysell, John, of Magna Ryburgh, husbandman 0
5012929 2360613 2360613 defendant Tryndell Alexander yeoman 595788 595788 Tryndell, Alexander, of Magna Ryburgh, yeoman 2
5020872 2363001 2363001 defendant Wylles John yeoman 595788 595788 Wylles, John, of Magna Ryburgh, yeoman 3
5052992 2372490 2372490 defendant Smyth Robert butcher 595788 595788 Smyth, Robert, of Magna Ryburgh, butcher 2
5060646 2374763 2374763 defendant Chaunceys William esq 595788 595788 Chaunceys, William, of Magna Ryburgh, esq 0
5070427 2377648 2377648 defendant Warner John husbandman 595788 595788 Warner, John, of Magna Ryburgh, husbandman 2
5070429 2377648 2377648 defendant Wylles John yeoman 595788 595788 Wylles, John, of Magna Ryburgh, yeoman 4
5074723 2378945 2378945 defendant Chaunceuxs William esq 595788 595788 Chaunceuxs, William, of Magna Ryburgh, esq 0
5232783 2425175 2425175 defendant Smyth Robert butcher 595788 595788 Smyth, Robert, of Magna Ryburgh, butcher 0
5296985 2444114 2444114 defendant Prynce John butcher 595788 595788 Prynce, John, of Magna Ryburgh, butcher 0
5325015 2452563 2452563 defendant Chamaney William husbandman 595788 595788 Chamaney, William, of Magna Ryburgh, husbandman 1
5349157 2459865 2459865 defendant Wethyr Henry yeoman 595788 595788 Wethyr, Henry, of Magna Ryburgh, yeoman 0
5349159 2459865 2459865 defendant Mabbys William yeoman 595788 595788 Mabbys, William, of Magna Ryburgh, yeoman 2
5352361 2460837 2460837 defendant Fell John husbandman 595788 595788 Fell, John, of Magna Ryburgh, husbandman 0
5352370 2460839 2460839 defendant Nell John husbandman 595788 595788 Nell, John, of Magna Ryburgh, husbandman 0
5482404 2499678 2499678 defendant Mylles John, junior miller 595788 595788 Mylles, John, junior, of Magna Ryburgh, miller 1
5535826 2515710 2515710 defendant Myller Nicholas husbandman 595788 595788 Myller, Nicholas, of Magna Ryburgh, husbandman 2
5540441 2517141 2517141 plaintiff Hervy Robert   595788 595788 Hervy, Robert, of Magna Ryburgh 0
5547049 2519143 2519143 defendant Andrewe Thomas gent 595788 595788 Andrewe, Thomas, of Magna Ryburgh, gent 0
5549657 2519947 2519947 defendant Gayton Thomas (legal representative) 595788 595788 Gayton, Thomas, of Magna Ryburgh, yeoman, executors of 0
5549663 2519948 2519948 defendant Gayton Thomas (legal representative) 595788 595788 Gayton, Thomas, of Magna Ryburgh, yeoman, executors of 2
5549664 2519948 2519948 defendant Gayton John husbandman 595788 595788 (Gayton, John, of Magna Ryburgh, husbandman 3
5549665 2519948 2519948 defendant Gayton Robert husbandman 595788 595788 Gayton, Robert, of Magna Ryburgh, husbandman 4
5549666 2519948 2519948 defendant Gayton Thomas husbandman 595788 595788 Gayton, Thomas, of Magna Ryburgh, husbandman 5
5558886 2522549 2522549 defendant Gayton John yeoman 595788 595788 Gayton, John, of Magna Ryburgh, yeoman 0
5558887 2522549 2522549 defendant Gayton Robert yeoman 595788 595788 Gayton, Robert, of Magna Ryburgh, yeoman 1
5564666 2524251 2524251 defendant Geyton John husbandman 595788 595788 (Geyton, John, of Magna Ryburgh, husbandman 1
5580764 2529063 2529063 defendant Thompson Robert husbandman 595788 595788 Thompson, Robert, of Magna Ryburgh, husbandman 1
5581829 2529396 2529396 defendant Andrevy William gent 595788 595788 Andrevy, William, of Magna Ryburgh, gent 0
5585881 2530637 2530637 defendant Andrewe William gent 595788 595788 Andrewe, William, of Magna Ryburgh, gent, son of Andrewe, Thomas, of Magna Ryburgh, gent 0
5593484 2532946 2532946 defendant Farewell John clerk 595788 595788 Farewell, John, of Magna Ryburgh, clerk 0
5606213 2536836 2536836 defendant Parson Robert   595788 595788 Parson, Robert, of Magna Ryburgh, shepherd 3

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