names

42 rows where place_id = 593361

✎ 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
3611487 1871266 1871266 defendant Rollesley John gent 593361 593361 Rollesley, John, of Derley, gent 2
3611488 1871266 1871266 defendant Fox Roger yeoman 593361 593361 Fox, Roger, of Derley, yeoman 3
3649916 1910338 1910338 defendant Wylle Thomas laborer 593361 593361 Wylle, Thomas, of Derley, laborer 0
3696040 1924996 1924996 defendant Wayte John yeoman 593361 593361 Wayte, John, of Derley, yeoman 2
3714376 1930793 1930793 defendant Wayt John yeoman 593361 593361 Wayt, John, of Derley, yeoman 2
3804150 1959227 1959227 defendant Weytoft James husbandman 593361 593361 Weytoft, James, of Derley, husbandman 0
3889166 1986613 1986613 defendant Whetcrofte James husbandman 593361 593361 Whetcrofte, James, of Derley, husbandman 1
4483885 2195656 2195656 defendant Flesshewer Macm   593361 593361 Flesshewer, Macm, of Derley 0
4511037 2203901 2203901 defendant Columbell John   593361 593361 Columbell, John, of Derley 0
4579063 2224932 2224932 plaintiff Columbell John   593361 593361 Columbell, John, of Derley 0
4609798 2234158 2234158 defendant Wyllymotte Robert   593361 593361 Wyllymotte, Robert, of Derley 0
4609799 2234158 2234158 defendant Heynes John   593361 593361 Heynes, John, of Derley 1
4609800 2234158 2234158 defendant Sonyour John   593361 593361 Sonyour, John, of Derley 2
4623073 2238193 2238193 defendant Columbell John   593361 593361 Columbell, John, of Derley 0
4643642 2244242 2244242 plaintiff Kybbeworth Robert de   593361 593361 Kybbeworth, Robert de, of Derley, parson of part of the church 0
4658062 2248399 2248399 defendant Conabell John esq 593361 593361 Conabell, John, of Derley, esq 1
4659803 2248916 2248916 defendant Columbell John esq 593361 593361 Columbell, John, of Derley, esq 0
4682794 2260236 2260236 defendant Columbell John gent 593361 593361 Columbell, John, of Derley, gent 0
4682796 2260236 2260236 defendant Jacson Roger husbandman 593361 593361 Jacson, Roger, of Derley, husbandman 2
4720704 2271809 2271809 defendant Andrewe William butcher 593361 593361 Andrewe, William, of Derley, butcher 1
4749952 2280458 2280458 defendant Columbell John gent 593361 593361 Columbell, John, of Derley, gent 0
4760928 2283759 2283759 plaintiff Colmon Richard   593361 593361 Colmon, Richard, of Derley 1
4769754 2286511 2286511 defendant Columbell John gent 593361 593361 Columbell, John, of Derley, gent 0
4791571 2293457 2293457 defendant Columbell John esq 593361 593361 Columbell, John, of Derley, esq 0
4794275 2294350 2294350 defendant Columbell John gent 593361 593361 Columbell, John, of Derley, gent 0
4853982 2312654 2312654 defendant Neuton Roger   593361 593361 Neuton, Roger, of Derley, abbot 0
4969825 2347921 2347921 defendant Prynne William husbandman 593361 593361 Prynne, William, of Derley, husbandman 1
5042368 2369324 2369324 plaintiff de Newton Roger   593361 593361 de Newton, Roger, of Derley, abbot of Darley 0
5435151 2485444 2485444 defendant Columbyne Henry gent 593361 593361 Columbyne, Henry, of Derley, gent 0
5528992 2513587 2513587 defendant Typpyng Richard laborer 593361 593361 Typpyng, Richard, of Derley, laborer 3
5528993 2513587 2513587 defendant Pydcok William laborer 593361 593361 Pydcok, William, of Derley, laborer 4
5529001 2513590 2513590 defendant Wyllymot Henry laborer 593361 593361 Wyllymot, Henry, of Derley, laborer 2
5534570 2515354 2515354 defendant Hunt Thomas laborer 593361 593361 Hunt, Thomas, of Derley, laborer 19
5578445 2528329 2528329 defendant Stokys Ellen widow 593361 593361 Stokys, Ellen, of Derley, widow 0
5578636 2528386 2528386 defendant Meltham Giles miner 593361 593361 Meltham, Giles, of Derley, miner 15
5578637 2528386 2528386 defendant Typpyng John miner 593361 593361 Typpyng, John, of Derley, miner 16
5583663 2529962 2529962 defendant Stere Edward miner 593361 593361 Stere, Edward, of Derley, miner 12
5589817 2531805 2531805 defendant Typpyng John miner 593361 593361 Typpyng, John, of Derley, miner 0
5589818 2531805 2531805 defendant Pyekar William miner 593361 593361 Pyekar, William, of Derley, miner 1
5589819 2531805 2531805 defendant Meltham Giles miner 593361 593361 Meltham, Giles, of Derley, miner 2
5589820 2531805 2531805 defendant Hunt John miner 593361 593361 Hunt, John, of Derley, miner 3
5589821 2531805 2531805 defendant Holenworth William miner 593361 593361 Holenworth, William, of Derley, miner 4

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