names

74 rows where place_id = 592003

✎ 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
3606276 1869631 1869631 defendant Eyton Robert yeoman 592003 592003 Eyton, Robert, of Groby, yeoman 0
4457084 2187224 2187224 defendant Ferrar Henry   592003 592003 together with Ferrar, Henry, of Groby, knight 1
4498160 2200081 2200081 plaintiff Ferrarijs William de   592003 592003 Ferrarijs, William de, of Groby, knight 0
4520274 2206683 2206683 plaintiff Ferrarijs William de   592003 592003 Ferrarijs, William de, of Groby, knight 0
4552420 2216710 2216710 plaintiff Ferraijs William de   592003 592003 Ferraijs, William de, of Groby, knight 0
4552422 2216711 2216711 plaintiff Ferrarijs William de   592003 592003 Ferrarijs, William de, of Groby, knight 0
4552424 2216712 2216712 plaintiff Ferrarijs William de   592003 592003 Ferrarijs, William de, of Groby, knight 0
4582844 2226067 2226067 plaintiff Ferrarijs William   592003 592003 Ferrarijs, William, of Groby, knight 0
4582846 2226068 2226068 plaintiff Ferrarijs William   592003 592003 Ferrarijs, William, of Groby, knight 0
4675260 2257874 2257874 plaintiff Ferrarijs William de   592003 592003 Ferrarijs, William de, of Groby, knight 0
4675265 2257875 2257875 plaintiff Ferrarijs William   592003 592003 Ferrarijs, William, of Groby, knight 0
4692083 2263054 2263054 defendant Ferrarijs William de   592003 592003 Ferrarijs, William de, of Groby, knight 2
4692085 2263055 2263055 defendant Ferrarijs William de   592003 592003 Ferrarijs, William de, of Groby, knight 0
4692089 2263056 2263056 defendant Ferrarijs William de   592003 592003 Ferrarijs, William de, of Groby, knight 0
4710766 2268722 2268722 defendant Ferrarijs William de   592003 592003 Ferrarijs, William de, of Groby, knight 0
4724112 2272835 2272835 defendant Sament John husbandman 592003 592003 Sament, John, of Groby, husbandman 3
4724789 2273051 2273051 plaintiff Ferrarijs Walter de   592003 592003 Ferrarijs, Walter de, of Groby, knight 0
4744782 2278991 2278991 plaintiff Ferrariis Edmund de   592003 592003 Ferrariis, Edmund de, of Groby, knight 0
4744795 2278995 2278995 plaintiff Ferrers William   592003 592003 Ferrers, William, of Groby, knight 0
4744797 2278996 2278996 plaintiff Ferrers William   592003 592003 Ferrers, William, of Groby, knight 0
4762231 2284167 2284167 plaintiff Ferrarijs William de   592003 592003 Ferrarijs, William de, of Groby, knight 0
4762233 2284168 2284168 plaintiff Ferrarijs William de   592003 592003 Ferrarijs, William de, of Groby, knight 0
4810544 2299443 2299443 plaintiff Ferrarirs William de   592003 592003 Ferrarirs, William de, of Groby, knight 0
4810550 2299445 2299445 plaintiff Ferrarys William   592003 592003 Ferrarys, William, of Groby, knight 0
4825605 2304051 2304051 defendant Skylmey John husbandman 592003 592003 Skylmey, John, of Groby, husbandman 1
4833031 2306348 2306348 defendant Aleyn John laborer 592003 592003 Aleyn, John, of Groby, laborer 4
4852166 2312107 2312107 defendant Samon John husbandman 592003 592003 Samon, John, of Groby, husbandman 0
4940300 2338988 2338988 plaintiff de Ferrarys William   592003 592003 de Ferrarys, William, of Groby, knight 0
4962339 2345637 2345637 defendant Proctor William yepoman 592003 592003 Proctor, William, of Groby, yepoman 0
4994296 2355167 2355167 plaintiff Ferrarijs Thomas de, sen   592003 592003 Ferrarijs, Thomas de, sen, of Groby 0
4994297 2355167 2355167 defendant Grey Thomas   592003 592003 Grey, Thomas, of Groby, knight 0
4996042 2355670 2355670 plaintiff Grey Edward   592003 592003 Grey, Edward, of Groby, knight, lord of Ferrarijs 0
5019462 2362575 2362575 plaintiff de Ferraris Thomas, senior   592003 592003 de Ferraris, Thomas, senior, of Groby 0
5019463 2362575 2362575 defendant Grey Thomas   592003 592003 Grey, Thomas, of Groby, knight 0
5025240 2364276 2364276 defendant Goolde William gent 592003 592003 together with Goolde, William, of Groby, gent 2
5025241 2364276 2364276 defendant Aynesworth James yeoman 592003 592003 Aynesworth, James, of Groby, yeoman 3
5025243 2364277 2364277 defendant Goolde William gent 592003 592003 Goolde, William, of Groby, gent 0
5025244 2364277 2364277 defendant Aynesworth James yeoman 592003 592003 Aynesworth, James, of Groby, yeoman 1
5025250 2364278 2364278 defendant Goolde William gent 592003 592003 Goolde, William, of Groby, gent 2
5025251 2364278 2364278 defendant Aynesworth James yeoman 592003 592003 Aynesworth, James, of Groby, yeoman 3
5052820 2372435 2372435 defendant Standyssh Nicholas   592003 592003 Standyssh, Nicholas, of Groby, chaplain, dwelling with William Lord of Groby 4
5070941 2377801 2377801 defendant Samon John husbandman 592003 592003 Samon, John, of Groby, husbandman 1
5076819 2379562 2379562 defendant Proctour William yeoman 592003 592003 Proctour, William,of Groby, yeoman 0
5076820 2379562 2379562 defendant Hyns Gilbert yeoman 592003 592003 Hyns, Gilbert, of Groby, yeoman 1
5076822 2379562 2379562 defendant Payle Ralph yeoman 592003 592003 Payle, Ralph, of Groby, yeoman 3
5082716 2381332 2381332 defendant Mylner Robert miller 592003 592003 Mylner, Robert, of Groby, miller 0
5087289 2382663 2382663 defendant Proktour William yeoman 592003 592003 Proktour, William, of Groby, yeoman 0
5112125 2389930 2389930 defendant Typper John yeoman 592003 592003 Typper, John, of Groby, yeoman 0
5137657 2397528 2397528 plaintiff Proctoure William yeoman 592003 592003 Proctoure, William, of Groby, yeoman 0
5158325 2403560 2403560 plaintiff Proctour William yeoman 592003 592003 Proctour, William, of Groby, yeoman 0
5178987 2409578 2409578 defendant Grey Elizabeth   592003 592003 Grey, Elizabeth, of Groby, widow, formerly wife of Edward Grey, knight, alias Lady de Ferrarijs & Groby 0
5278712 2438880 2438880 defendant Leylond Robert yeoman 592003 592003 Leylond, Robert, of Groby, yeoman 0
5285855 2440886 2440886 defendant Leylond Robert yeoman 592003 592003 Leylond, Robert, of Groby, yeoman 3
5285857 2440886 2440886 defendant Persons Thomas yeoman 592003 592003 Persons, Thomas, of Groby, yeoman 5
5285858 2440886 2440886 defendant Austyn John miller 592003 592003 Austyn, John, of Groby, miller 6
5285879 2440887 2440887 defendant Leylond Robert yeoman 592003 592003 Leylond, Robert, of Groby, yeoman 8
5299825 2444917 2444917 defendant Bourghchier John   592003 592003 Bourghchier, John, of Groby, knight 0
5313235 2448993 2448993 defendant Coke John yeoman 592003 592003 Coke, John, of Groby, yeoman 0
5316053 2449877 2449877 defendant Grey Edward   592003 592003 Grey, Edward, of Groby, knight, Lord Lysley 0
5316070 2449881 2449881 defendant Burbryke Robert husbandman 592003 592003 Burbryke, Robert, of Groby, husbandman 0
5325707 2452768 2452768 defendant Grey Edward   592003 592003 Grey, Edward, of Groby, knight 0
5328608 2453634 2453634 defendant Bourchier John   592003 592003 Bourchier, John, of Groby, knight 0
5333342 2455044 2455044 defendant Grey Edward   592003 592003 Grey, Edward, of Groby, knight, Lord Lysle 0
5333344 2455045 2455045 defendant Grey Edward   592003 592003 Grey, Edward, of Groby, knight, Lord Lysle 0
5353692 2461220 2461220 defendant Bourgchier John   592003 592003 Bourgchier, John, of Groby, knight 0
5427787 2483269 2483269 plaintiff Eyre John   592003 592003 Eyre, John, of Groby 0
5445417 2488528 2488528 plaintiff Eyre John   592003 592003 Eyre, John, of Groby 0
5458160 2492348 2492348 plaintiff Eyre John   592003 592003 Eyre, John, of Groby 0
5458163 2492349 2492349 plaintiff Eyre John   592003 592003 Eyre, John, of Groby 0
5480678 2499184 2499184 defendant Grey Henry esq 592003 592003 Grey, Henry, of Groby, esq 3
5481204 2499330 2499330 plaintiff Eyre John   592003 592003 Eyre, John, of Groby 0
5481207 2499331 2499331 plaintiff Eyre John   592003 592003 Eyre, John, of Groby 0
5528380 2513416 2513416 defendant Hunt Robert yeoman 592003 592003 Hunt, Robert, of Groby, yeoman 1
5573883 2526928 2526928 defendant Aldey Richard clerk 592003 592003 Aldey, Richard, of Groby, 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);