names

119 rows where place_id = 600022

✎ 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
3639375 1907124 1907124 defendant Boland Thomas miller 600022 600022 (Boland, Thomas, of Boxle, miller 1
3641585 1907828 1907828 defendant Pyrkyn Richard husbandman 600022 600022 Pyrkyn, Richard, of Boxle, husbandman 0
4184679 2090151 2090151 defendant Wilman Thomas butcher 600022 600022 Wilman, Thomas, of Boxle, butcher 2
4458045 2187545 2187545 defendant French John   600022 600022 French, John, of Boxle 1
4467849 2190624 2190624 defendant Burdon Geoffrey   600022 600022 Burdon, Geoffrey, of Boxle 0
4468457 2190800 2190800 defendant Burdon Geoffrey   600022 600022 Burdon, Geoffrey, of Boxle 0
4574154 2223441 2223441 plaintiff Bele John   600022 600022 Bele, John, of Boxle 0
4574156 2223442 2223442 plaintiff Bele John   600022 600022 Bele, John, of Boxle 0
4574158 2223442 2223442 defendant Clerk Robert   600022 600022 Clerk, Robert, of Boxle 1
4595865 2229963 2229963 defendant Counsayl Henry   600022 600022 Counsayl, Henry, of Boxle 0
4607936 2233603 2233603 defendant Dore Thomas   600022 600022 Dore, Thomas, of Boxle 0
4637718 2242574 2242574 defendant Grandon John   600022 600022 Grandon, John, of Boxle 4
4637725 2242575 2242575 defendant Grandon John   600022 600022 Grandon, John, of Boxle 4
4652313 2246676 2246676 defendant Doraunt Richard porter 600022 600022 Doraunt, Richard, of Boxle, porter 1
4785429 2291463 2291463 defendant Dore Henry husbandman 600022 600022 Dore, Henry, of Boxle, husbandman 0
4785430 2291463 2291463 defendant Clerk Robert husbandman 600022 600022 Clerk, Robert, of Boxle, husbandman 1
4808720 2298894 2298894 defendant Cartere Roger husbandman 600022 600022 Cartere, Roger, of Boxle, husbandman 1
4818993 2302019 2302019 defendant atte Wode John yeoman 600022 600022 atte Wode, John, of Boxle, yeoman 3
4818999 2302020 2302020 defendant atte Wode John yeoman 600022 600022 atte Wode, John, of Boxle, yeoman 3
4868331 2317071 2317071 defendant Burbage John husbandman 600022 600022 Burbage, John, of Boxle, husbandman 1
4871172 2317960 2317960 defendant Snergate Richard husbandman 600022 600022 Snergate, Richard, of Boxle, husbandman 0
4873978 2318800 2318800 defendant atte Wode John husbandman 600022 600022 atte Wode, John, of Boxle, husbandman 0
4884230 2321976 2321976 defendant Benet John   600022 600022 Benet, John, of Boxle, mason 0
4894083 2324847 2324847 defendant Joce William yeoman 600022 600022 together with Joce, William, of Boxle, yeoman 1
4894085 2324848 2324848 defendant Joce William yeoman 600022 600022 Joce, William, of Boxle, yeoman 0
4905678 2328377 2328377 defendant Joce William yeoman 600022 600022 Joce, William, of Boxle, yeoman 0
4917940 2332127 2332127 defendant Hale Henry laborer 600022 600022 Hale, Henry, of Boxle, laborer 0
4942539 2339646 2339646 defendant Lokkefeld Richard shingler 600022 600022 Lokkefeld, Richard, of Boxle, shingler 2
4948861 2341627 2341627 defendant Burbage John husbandman 600022 600022 (Burbage, John, of Boxle, husbandman 1
4969163 2347738 2347738 defendant Beneyt John   600022 600022 Beneyt, John, of Boxle, mason 0
4986236 2352812 2352812 defendant Meriweder John husbandman 600022 600022 Meriweder, John, of Boxle, husbandman 2
4986249 2352816 2352816 defendant Cokyr John husbandman 600022 600022 Cokyr, John, of Boxle, husbandman 2
4986265 2352820 2352820 defendant Benet John husbandman 600022 600022 Benet, John, of Boxle, husbandman 0
5025184 2364261 2364261 defendant Snelgare Richard yeoman 600022 600022 Snelgare, Richard, of Boxle, yeoman 3
5050831 2371868 2371868 defendant Chelyngton John husbandman 600022 600022 Chelyngton, John, of Boxle, husbandman 2
5058144 2373998 2373998 defendant Snell or Suell Stephen laborer 600022 600022 Snell or Suell, Stephen, of Boxle, laborer 1
5058152 2373999 2373999 defendant Snelgore Richard yeoman 600022 600022 Snelgore, Richard, of Boxle, yeoman 0
5080832 2380757 2380757 defendant Rysshby Henry laborer 600022 600022 Rysshby, Henry, of Boxle, laborer 3
5083730 2381637 2381637 defendant Snelgare Richard yeoman 600022 600022 Snelgare, Richard, of Boxle, yeoman 1
5084479 2381872 2381872 defendant Lorkyn Robert laborer 600022 600022 Lorkyn, Robert, of Boxle, laborer 1
5107583 2388649 2388649 defendant Snelgare Richard yeoman 600022 600022 Snelgare, Richard, of Boxle, yeoman 0
5151616 2401628 2401628 defendant Snelgar Richard yeoman 600022 600022 Snelgar, Richard, of Boxle, yeoman 2
5159119 2403784 2403784 defendant Snelgare Richard yeoman 600022 600022 Snelgare, Richard, of Boxle, yeoman 0
5180938 2410164 2410164 defendant Asshby Henry yeoman 600022 600022 Asshby, Henry, of Boxle, yeoman 0
5180939 2410164 2410164 defendant Gollay Thomas laborer 600022 600022 Gollay, Thomas, of Boxle, laborer 1
5188751 2412438 2412438 defendant Snelgar Richard yeoman 600022 600022 Snelgar, Richard, of Boxle, yeoman 0
5218264 2421072 2421072 defendant Snelgare Richard yeoman 600022 600022 Snelgare, Richard, of Boxle, yeoman 1
5220559 2421710 2421710 defendant Snelgare Richard yeoman 600022 600022 Snelgare, Richard, of Boxle, yeoman 2
5223938 2422684 2422684 defendant Dore Thomas yeoman 600022 600022 Dore, Thomas, of Boxle, yeoman 3
5223939 2422684 2422684 defendant Burbage Robert yeoman 600022 600022 Burbage, Robert, of Boxle, yeoman 4
5224852 2422940 2422940 defendant Lane Richard laborer or carpenter 600022 600022 Lane, Richard, of Boxle, laborer or carpenter 0
5255239 2431754 2431754 defendant Snelgar Richard yeoman 600022 600022 Snelgar, Richard, of Boxle, yeoman 1
5259481 2433086 2433086 defendant Hastelyn John laborer 600022 600022 Hastelyn, John, of Boxle, laborer 0
5267325 2435545 2435545 defendant atte Lane Richard laborer 600022 600022 atte Lane, Richard, of Boxle, laborer 0
5267326 2435545 2435545 defendant Person John laborer 600022 600022 Person, John, of Boxle, laborer 1
5267327 2435545 2435545 defendant May Thomas smith 600022 600022 May, Thomas, of Boxle, smith 2
5275896 2438021 2438021 plaintiff Strets alias Smyth Thomas   600022 600022 Strets alias Smyth, Thomas, of Boxle 1
5283474 2440218 2440218 defendant Hoigge Stephen husbandman 600022 600022 Hoigge, Stephen, of Boxle, husbandman 2
5293114 2442969 2442969 defendant Porter John husbandman 600022 600022 Porter, John, of Boxle, husbandman 2
5321193 2451436 2451436 defendant Ashby Henry husbandman 600022 600022 Ashby, Henry, of Boxle, husbandman 1
5321458 2451509 2451509 defendant Lane Richard carpenter 600022 600022 Lane, Richard, of Boxle, carpenter 2
5324434 2452392 2452392 defendant Chambre Thomas yeoman 600022 600022 Chambre, Thomas, of Boxle, yeoman 1
5324435 2452392 2452392 defendant Turke Richard husbandman 600022 600022 Turke, Richard, of Boxle, husbandman 2
5324436 2452392 2452392 defendant Meryweder Roger yeoman 600022 600022 Meryweder, Roger, of Boxle, yeoman 3
5332651 2454833 2454833 defendant Dore Richard husbandman 600022 600022 Dore, Richard, of Boxle, husbandman 1
5347464 2459371 2459371 defendant Lane Richard yeoman 600022 600022 Lane, Richard, of Boxle, yeoman 0
5356092 2461983 2461983 defendant Chaleys Thomas husbandman 600022 600022 Chaleys, Thomas, of Boxle, husbandman 0
5363946 2464376 2464376 defendant Carter John husbandman 600022 600022 Carter, John, of Boxle, husbandman 3
5372832 2467105 2467105 defendant Corly Walter husbandman 600022 600022 Corly, Walter, of Boxle, husbandman 1
5384934 2470764 2470764 defendant Stretys Thomas husbandman 600022 600022 Stretys, Thomas, of Boxle, husbandman 0
5384935 2470764 2470764 defendant Stretys John husbandman 600022 600022 Stretys, John, of Boxle, husbandman 1
5394163 2473391 2473391 defendant Boland Robert husbandman 600022 600022 Boland, Robert, of Boxle, husbandman 1
5396963 2474214 2474214 defendant Stretys Thomas husbandman 600022 600022 Stretys, Thomas, of Boxle, husbandman 0
5396964 2474214 2474214 defendant Stretys John husbandman 600022 600022 Stretys, John, of Boxle, husbandman 1
5396988 2474220 2474220 defendant Strelys Thomas husbandman 600022 600022 Strelys, Thomas, of Boxle, husbandman 0
5396989 2474220 2474220 defendant Strekys of Strelys John husbandman 600022 600022 Strekys of Strelys, John, of Boxle, husbandman 1
5399440 2474916 2474916 defendant Hale John husbandman 600022 600022 Hale, John, of Boxle, husbandman 2
5399551 2474952 2474952 defendant Person Henry husbandman 600022 600022 Person, Henry, of Boxle, husbandman 2
5399955 2475077 2475077 defendant Spparowe Thomas yeoman 600022 600022 Spparowe, Thomas, of Boxle, yeoman 2
5412941 2478816 2478816 defendant Sparowe Thomas yeoman 600022 600022 Sparowe, Thomas, of Boxle, yeoman 2
5423595 2482021 2482021 defendant Kember Thomas husbandman 600022 600022 Kember, Thomas, of Boxle, husbandman 0
5427998 2483325 2483325 defendant Sparowe Thomas yeoman 600022 600022 Sparowe, Thomas, of Boxle, yeoman 2
5431922 2484516 2484516 defendant Squyer Robert   600022 600022 Squyer, Robert, of Boxle, mason 1
5434686 2485312 2485312 defendant Lumby Robert miller 600022 600022 Lumby, Robert, of Boxle, miller 0
5434687 2485312 2485312 defendant Lumby William laborer 600022 600022 Lumby, William, of Boxle, laborer 1
5441451 2487364 2487364 defendant Hale John husbandman 600022 600022 Hale, John, of Boxle, husbandman 2
5457699 2492200 2492200 defendant Hale John husbandman 600022 600022 Hale, John, of Boxle, husbandman 2
5462963 2493835 2493835 defendant Aysseby John laborer 600022 600022 Aysseby, John, of Boxle, laborer 2
5462964 2493835 2493835 defendant Kyng John laborer 600022 600022 Kyng, John, of Boxle, laborer 3
5462965 2493835 2493835 defendant Hoyte Robert yeoman 600022 600022 Hoyte, Robert, of Boxle, yeoman 4
5462966 2493835 2493835 defendant Costedyll Thomas yeoman 600022 600022 Costedyll, Thomas, of Boxle, yeoman 5
5462967 2493835 2493835 defendant Man John husbandman 600022 600022 Man, John, of Boxle, husbandman 6
5462968 2493835 2493835 defendant Man William husbandman 600022 600022 Man, William, of Boxle, husbandman 7
5462969 2493835 2493835 defendant Gybbys William laborer 600022 600022 Gybbys, William, of Boxle, laborer 8
5462971 2493835 2493835 defendant Meriweder Roger laborer 600022 600022 Meriweder, Roger, of Boxle, laborer 10
5462972 2493835 2493835 defendant Tylby Thomas laborer 600022 600022 Tylby, Thomas, of Boxle, laborer 11
5462973 2493835 2493835 defendant Kembar Thomas laborer 600022 600022 Kembar, Thomas, of Boxle, laborer 12
5465860 2494706 2494706 defendant Hayte Robert yeoman 600022 600022 Hayte, Robert, of Boxle, yeoman 0
5474502 2497354 2497354 defendant Meriweder Roger laborer 600022 600022 Meriweder, Roger, of Boxle, laborer 10
5474503 2497354 2497354 defendant Tylby (illegible) laborer 600022 600022 Tylby, _, of Boxle, laborer 11

Next page

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