names

88 rows where place_id = 592855

✎ 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
3609175 1870529 1870529 defendant Coton Stephen yeoman 592855 592855 Coton, Stephen, of Colshull, yeoman 0
3690364 1923149 1923149 defendant Grendon Hugh tailor 592855 592855 Grendon, Hugh, of Colshull, tailor 2
3727702 1934933 1934933 defendant Balle Nicholas butcher 592855 592855 Balle, Nicholas, of Colshull, butcher 0
3775112 1949948 1949948 defendant Shylton Richard corveser 592855 592855 Shylton, Richard, of Colshull, corveser 0
3775113 1949948 1949948 defendant Grene John corveser 592855 592855 Grene, John, of Colshull, corveser 1
3775114 1949948 1949948 defendant Sylk John tiler 592855 592855 Sylk, John, of Colshull, tiler 2
4449819 2184893 2184893 plaintiff Grene John   592855 592855 Grene, John, of Colshull 0
4487390 2196766 2196766 defendant Walkere John   592855 592855 Walkere, John, of Colshull 0
4487391 2196766 2196766 defendant Smyth John   592855 592855 Smyth, John, of Colshull 1
4527046 2208739 2208739 defendant More John   592855 592855 More, John, of Colshull 0
4527047 2208739 2208739 defendant Alyen John   592855 592855 Alyen, John, of Colshull 1
4527052 2208740 2208740 defendant More John   592855 592855 More, John, of Colshull 0
4527053 2208740 2208740 defendant Leycroft Robert   592855 592855 Leycroft, Robert, of Colshull 1
4543847 2213973 2213973 defendant Everdon Thomas   592855 592855 Everdon, Thomas, of Colshull 0
4543865 2213981 2213981 defendant Mountfort William   592855 592855 Mountfort, William, of Colshull 0
4549214 2215695 2215695 plaintiff Colyer John   592855 592855 Colyer, John, of Colshull 0
4580826 2225485 2225485 defendant Ibstoke Roger   592855 592855 Ibstoke, Roger, of Colshull 0
4592076 2228878 2228878 defendant Cok Robert   592855 592855 Cok, Robert, of Colshull 1
4604466 2232566 2232566 defendant Kybbell Richard   592855 592855 Kybbell, Richard, of Colshull 1
4606716 2233215 2233215 plaintiff Byndegyle William   592855 592855 (Byndegyle, William, of Colshull 1
4633346 2241286 2241286 defendant Taillour John   592855 592855 Taillour, John, of colshull 11
4637139 2242417 2242417 defendant Gower John   592855 592855 Gower, John, of Colshull 0
4637140 2242417 2242417 defendant Felpys John   592855 592855 Felpys, John, of Colshull 1
4639135 2242962 2242962 defendant del More John   592855 592855 del More, John, of Colshull 0
4654206 2247198 2247198 defendant Gower John   592855 592855 Gower, John, of Colshull 0
4654207 2247198 2247198 defendant Felpys John   592855 592855 Felpys, John, of Colshull 1
4658257 2248462 2248462 defendant More John yeoman 592855 592855 More, John, of Colshull, yeoman 0
4681003 2259682 2259682 defendant Aleyn John draper 592855 592855 Aleyn, John, of Colshull, draper 1
4681004 2259682 2259682 defendant Herman John yeoman 592855 592855 Herman, John, of Colshull, yeoman 2
4757268 2282648 2282648 plaintiff Botery Richard de la   592855 592855 Botery, Richard de la, of Colshull 0
4760062 2283486 2283486 defendant Walker Richard laborer 592855 592855 Walker, Richard, of Colshull, laborer 0
4775985 2288489 2288489 defendant Brokk or Brokkes John husbandman 592855 592855 Brokk or Brokkes, John, of Colshull, husbandman 0
4775986 2288489 2288489 defendant Bayly George husbandman 592855 592855 Bayly, George, of Colshull, husbandman 1
4797846 2295503 2295503 defendant Cadell Thomas   592855 592855 Cadell, Thomas, of Colshull 1
4807666 2298589 2298589 defendant Aleyn John yeoman 592855 592855 Aleyn, John, of Colshull, yeoman 1
4808193 2298740 2298740 plaintiff Couper William   592855 592855 Couper, William, of Colshull 0
4866832 2316590 2316590 defendant Aleyn John yeoman 592855 592855 Aleyn, John, of Colshull, yeoman 2
4870323 2317694 2317694 plaintiff Lycrofte William yeoman 592855 592855 Lycrofte, William, of Colshull, yeoman 0
4870325 2317694 2317694 plaintiff Deyster John yeoman 592855 592855 Deyster, John, of Colshull, yeoman 2
4871795 2318150 2318150 defendant Leycroft William yeoman 592855 592855 Leycroft, William, of Colshull, yeoman 0
4871802 2318153 2318153 plaintiff Mountfort William   592855 592855 Mountfort, William, of Colshull, knight 0
4927890 2335159 2335159 defendant Bonde Richard glover 592855 592855 Bonde, Richard, of Colshull, glover 0
4927892 2335159 2335159 defendant Baker Thomas husbandman 592855 592855 Baker, Thomas, of Colshull, husbandman 2
4989788 2353863 2353863 defendant Barre Robert tailor 592855 592855 Barre, Robert, of Colshull, tailor 4
4991846 2354446 2354446 defendant Whelewryght Robert husbandman 592855 592855 Whelewryght, Robert, of Colshull, husbandman 0
5009523 2359665 2359665 defendant Leycroft William husbandman 592855 592855 Leycroft, William, of Colshull, husbandman 0
5058292 2374030 2374030 defendant Smyth Thomas yeoman 592855 592855 Smyth, Thomas, of Colshull, yeoman 0
5087133 2382618 2382618 defendant Mountfort Robert esq 592855 592855 Mountfort, Robert, of Colshull, esq 1
5087137 2382619 2382619 defendant Mountfort Robert esq 592855 592855 Mountfort, Robert, of Colshull, esq 1
5100503 2386568 2386568 plaintiff Yonge Thomas   592855 592855 Yonge, Thomas, of Colshull 0
5103636 2387489 2387489 defendant Mountfort Joan widow 592855 592855 Mountfort, Joan, of Colshull, widow 0
5103638 2387490 2387490 defendant Mountfort William (legal representative) 592855 592855 Mountfort, William, of Colshull, knight, executors of 0
5103639 2387490 2387490 defendant Mountfort Joan widow 592855 592855 (Mountfort, Joan, of Colshull, widow 1
5103640 2387490 2387490 defendant Mountfort Edmund esq 592855 592855 Mountfort, Edmund, of Colshull, esq 2
5103642 2387491 2387491 defendant Mountfort William (legal representative) 592855 592855 Mountfort, William, of Colshull, knight, executors of 0
5103643 2387491 2387491 defendant Moutfort Joan widow 592855 592855 (Moutfort, Joan, of Colshull, widow 1
5103644 2387491 2387491 defendant Mountfort Edmund esq 592855 592855 Mountfort, Edmund, of Colshull, esq 2
5103646 2387492 2387492 defendant Moutfort Joan widow 592855 592855 Moutfort, Joan, of Colshull, widow 0
5104110 2387626 2387626 plaintiff Burton alias de Seller Thomas yeoman 592855 592855 Burton alias de Seller, Thomas, of Colshull, yeoman 0
5104111 2387626 2387626 defendant Lawson William baker 592855 592855 Lawson, William, of Colshull, baker 0
5135967 2397031 2397031 defendant Sawer Richard yeoman 592855 592855 Sawer, Richard, of Colshull, yeoman 5
5156254 2402987 2402987 defendant Sawer Richard yeoman 592855 592855 Sawer, Richard, of Colshull, yeoman 3
5156266 2402988 2402988 defendant Sawer Richrd yeoman 592855 592855 Sawer, Richrd, of Colshull, yeoman 5
5219207 2421340 2421340 defendant Chapman Thomas mercer 592855 592855 Chapman, Thomas, of Colshull, mercer 2
5241186 2427627 2427627 defendant Glover Richard glover 592855 592855 Glover, Richard, of Colshull, glover 0
5253579 2431229 2431229 defendant Baker Henry   592855 592855 Baker, Henry, of Colshull 0
5271726 2436830 2436830 defendant Catte (illegible) chaplain 592855 592855 Catte, ---, of Colshull, chaplain 1
5296582 2443988 2443988 defendant Hayteley William butcher 592855 592855 Hayteley, William, of Colshull, butcher 1
5301445 2445384 2445384 defendant Wegewode John yeoman 592855 592855 Wegewode, John, of Colshull, yeoman 0
5312287 2448711 2448711 defendant Sclatford Henry husbandman 592855 592855 Sclatford, Henry, of Colshull, husbandman 0
5347252 2459307 2459307 defendant Cheyny John yeoman 592855 592855 Cheyny, John, of Colshull, yeoman 1
5348103 2459550 2459550 defendant Cheyne John yeoman 592855 592855 Cheyne, John, of Colshull, yeoman 0
5359019 2462871 2462871 defendant Cheyne John yeoman 592855 592855 Cheyne, John, of Colshull, yeoman 1
5395696 2473852 2473852 defendant Baker Richard (legal representative) 592855 592855 Baker, Richard, of Colshull, yeoman, administrator of 0
5395699 2473852 2473852 defendant Crosse John walker 592855 592855 Crosse, John, of Colshull, walker 3
5408985 2477650 2477650 defendant Baker Richard   592855 592855 Baker, Richard, of Colshull, yeoman, administrators of 0
5408988 2477650 2477650 defendant Crosse John walker 592855 592855 Crosse, John, of Colshull, walker 3
5506943 2507087 2507087 defendant Preston William yeoman 592855 592855 Preston, William, of Colshull, yeoman 0
5506945 2507087 2507087 defendant Choise John laborer 592855 592855 Choise, John, of Colshull, laborer 2
5519157 2510836 2510836 defendant Lyle John gent 592855 592855 Lyle, John, of Colshull, gent 5
5541937 2517599 2517599 defendant Couper John husbandman 592855 592855 Couper, John, of Colshull, husbandman 0
5541939 2517599 2517599 defendant Comaunder John smith 592855 592855 Comaunder, John, of Colshull, smith 2
5616071 2548822 2548822 defendant Martyn William   592855 592855 Martyn, William, of Colshull 0
5625179 2551815 2551815 defendant Herman John yeoman 592855 592855 Herman, John, of Colshull, yeoman 0
5626707 2552327 2552327 plaintiff Mountfort William   592855 592855 Mountfort, William, of Colshull 0
5626709 2552328 2552328 plaintiff Mountfort William   592855 592855 Mountfort, William, of Colshull 0
5626714 2552329 2552329 plaintiff Mountfort William   592855 592855 Mountfort, William, of Colshull, kinsman of John son of Lawrence, of Ulbhale 0
5626716 2552330 2552330 plaintiff Mountfort William   592855 592855 Mountfort, William, of Colshull 0

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