names

76 rows where place_id = 627571

✎ 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
3777063 1950573 1950573 defendant Storer Thomas husbandman 627571 627571 Storer, Thomas, of Gaddesby, husbandman 0
3783552 1952613 1952613 defendant Weyn Richard yeoman 627571 627571 Weyn, Richard, of Gaddesby, yeoman 0
4452968 2185934 2185934 defendant Rose William   627571 627571 Rose, William, of Gaddesby 0
4475995 2193158 2193158 defendant Mote Thomas   627571 627571 Mote, Thomas, of Gaddesby;Sherman, John, of Uppyngham 2
4493683 2198722 2198722 plaintiff Battesson William   627571 627571 Battesson, William, of Gaddesby, on his own account 0
4493684 2198722 2198722 defendant Randolf Roger   627571 627571 Randolf, Roger, of Gaddesby 0
4497543 2199875 2199875 defendant Baudewyne Roger   627571 627571 Baudewyne, Roger, of Gaddesby 1
4521325 2207014 2207014 plaintiff Baudewyn Roger   627571 627571 Baudewyn, Roger, of Gaddesby 1
4551182 2216312 2216312 defendant Baudewyn Roger   627571 627571 Baudewyn, Roger, of Gaddesby 0
4615509 2235853 2235853 defendant Mote Thomas   627571 627571 Mote, Thomas, of Gaddesby 0
4632043 2240905 2240905 defendant Whateley William   627571 627571 Whateley, William, of Gaddesby 0
4698584 2265031 2265031 defendant Broghton Robert husbandman 627571 627571 Broghton, Robert, of Gaddesby, husbandman 0
4710527 2268652 2268652 defendant Tounesende William husbandman 627571 627571 Tounesende, William, of Gaddesby, husbandman 0
4718594 2271153 2271153 defendant Paskehall Robert butcher 627571 627571 Paskehall, Robert, of Gaddesby, butcher 2
4733611 2275688 2275688 defendant Pascall Robert butcher 627571 627571 Pascall, Robert, of Gaddesby, butcher 0
4733612 2275688 2275688 defendant Grache Robert husbandman 627571 627571 Grache, Robert, of Gaddesby, husbandman 1
4733613 2275688 2275688 defendant Browton Robert husbandman 627571 627571 Browton, Robert, of Gaddesby, husbandman 2
4750392 2280597 2280597 defendant Pyns John husabndman 627571 627571 Pyns, John, of Gaddesby, husabndman 0
4766190 2285417 2285417 defendant Blak Ralph husbandman 627571 627571 Blak, Ralph, of Gaddesby, husbandman 0
4876993 2319775 2319775 defendant Clerk Thomas yeoman 627571 627571 Clerk, Thomas, of Gaddesby, yeoman 4
4959435 2344788 2344788 defendant Danet or Davet John esq 627571 627571 Danet or Davet, John, of Gaddesby, esq 0
4995595 2355520 2355520 defendant Danet John esq 627571 627571 Danet, John, of Gaddesby, esq 0
4995920 2355627 2355627 defendant Danet John esq 627571 627571 Danet, John, of Gaddesby, esq 0
4998960 2356569 2356569 defendant Danet John esq 627571 627571 Danet, John, of Gaddesby, esq 0
4999135 2356618 2356618 defendant Clerke Thomas husbandman 627571 627571 Clerke, Thomas, of Gaddesby, husbandman 2
5006074 2358664 2358664 defendant Danet John esq 627571 627571 Danet, John, of Gaddesby, esq 0
5022516 2363486 2363486 defendant Danet or Davet John esq 627571 627571 Danet or Davet, John, of Gaddesby, esq 0
5025974 2364492 2364492 defendant Danet or Davet John esq 627571 627571 Danet or Davet, John, of Gaddesby, esq 0
5033804 2366769 2366769 defendant Clerk Henry husbandman 627571 627571 Clerk, Henry, of Gaddesby, husbandman 0
5033814 2366772 2366772 defendant Tounesend William yeoman 627571 627571 Tounesend, William, of Gaddesby, yeoman 0
5033815 2366772 2366772 defendant Blak Ralph husbandman 627571 627571 Blak, Ralph, of Gaddesby, husbandman 1
5033816 2366772 2366772 defendant Wryght Roger husbandman 627571 627571 Wryght, Roger, of Gaddesby, husbandman 2
5033817 2366772 2366772 defendant Clerk Henry husbandman 627571 627571 Clerk, Henry, of Gaddesby, husbandman 3
5039871 2368567 2368567 defendant Mon Richard husbandman 627571 627571 Mon, Richard, of Gaddesby, husbandman 0
5045469 2370274 2370274 defendant Danet John esq 627571 627571 Danet, John, of Gaddesby, esq 0
5047952 2371007 2371007 defendant Wryght William husbandman 627571 627571 Wryght, William, of Gaddesby, husbandman 0
5047954 2371007 2371007 defendant Chekeley John husbandman 627571 627571 Chekeley, John, of Gaddesby, husbandman 2
5051971 2372202 2372202 defendant Monk Richard husbandman 627571 627571 Monk, Richard, of Gaddesby, husbandman 0
5053663 2372699 2372699 defendant Monk Richard husbandman 627571 627571 Monk, Richard, of Gaddesby, husbandman 2
5053665 2372699 2372699 defendant Daventre John husbandman 627571 627571 Daventre, John, of Gaddesby, husbandman 4
5068728 2377143 2377143 defendant Daventre John husbandman 627571 627571 Daventre, John, of Gaddesby, husbandman 2
5073434 2378539 2378539 defendant Sandy John yeoman 627571 627571 Sandy, John, of Gaddesby, yeoman 0
5075018 2379030 2379030 defendant Bleke Ralph husbandman 627571 627571 Bleke, Ralph, of Gaddesby, husbandman 2
5091357 2383871 2383871 defendant Blak Ralph husbandman 627571 627571 Blak, Ralph, of Gaddesby, husbandman 0
5091358 2383871 2383871 defendant Monk William husbandman 627571 627571 Monk, William, of Gaddesby, husbandman 1
5091359 2383871 2383871 defendant Buk William husbandman 627571 627571 Buk, William, of Gaddesby, husbandman 2
5091360 2383871 2383871 defendant Humberston William husbandman 627571 627571 Humberston, William, of Gaddesby, husbandman 3
5091361 2383871 2383871 defendant Sande John yeoman 627571 627571 Sande, John, of Gaddesby, yeoman 4
5091362 2383871 2383871 defendant Kempe William laborer 627571 627571 Kempe, William, of Gaddesby, laborer 5
5091363 2383871 2383871 defendant Blak William husbandman 627571 627571 Blak, William, of Gaddesby, husbandman 6
5091372 2383872 2383872 defendant Blak Raph husbandman 627571 627571 Blak, Raph, of Gaddesby, husbandman 0
5091373 2383872 2383872 defendant Monk William husbandman 627571 627571 Monk, William,of Gaddesby, husbandman 1
5091374 2383872 2383872 defendant Buk William husbandman 627571 627571 Buk, William, of Gaddesby, husbandman 2
5091375 2383872 2383872 defendant Humberston William husbandman 627571 627571 Humberston, William, of Gaddesby, husbandman 3
5091376 2383872 2383872 defendant Sande John yeoman 627571 627571 Sande, John, of Gaddesby, yeoman 4
5091377 2383872 2383872 defendant Kemp William laborer 627571 627571 Kemp, William, of Gaddesby, laborer 5
5091378 2383872 2383872 defendant Blak William husbandman 627571 627571 Blak, William, of Gaddesby, husbandman 6
5099835 2386390 2386390 defendant Blak Ralph husbandman 627571 627571 Blak, Ralph, of Gaddesby, husbandman 5
5099836 2386390 2386390 defendant Nicoll John husbandman 627571 627571 Nicoll, John, of Gaddesby, husbandman 6
5099841 2386391 2386391 defendant Sandy John yeoman 627571 627571 Sandy, John, of Gaddesby, yeoman 3
5116566 2391278 2391278 defendant Kempe William yeoman 627571 627571 Kempe, William, of Gaddesby, yeoman 0
5215022 2420115 2420115 defendant Sandy John yeoman 627571 627571 Sandy, John, of Gaddesby, yeoman 1
5215024 2420116 2420116 defendant Sandy John yeoman 627571 627571 Sandy, John, of Gaddesby, yeoman 0
5275367 2437866 2437866 defendant Derby William gent 627571 627571 Derby, William, of Gaddesby, gent 5
5299283 2444761 2444761 defendant Monke William yeoman 627571 627571 Monke, William, of Gaddesby, yeoman 0
5339907 2457051 2457051 plaintiff Mounk William   627571 627571 Mounk, William, of Gaddesby 0
5339908 2457051 2457051 plaintiff Bell William   627571 627571 Bell, William, of Gaddesby 1
5357239 2462326 2462326 defendant Lewyn William laborer 627571 627571 Lewyn, William, of Gaddesby, laborer 0
5441361 2487334 2487334 defendant Cartar John weaver 627571 627571 Cartar, John, of Gaddesby, weaver 0
5447830 2489233 2489233 defendant Carter John weaver 627571 627571 Carter, John, of Gaddesby, weaver 0
5460228 2492994 2492994 defendant Carter John weaver 627571 627571 Carter, John, of Gaddesby, weaver 0
5483267 2499940 2499940 defendant Carter John weaver 627571 627571 Carter, John, of Gaddesby, weaver 0
5523704 2512243 2512243 defendant Marten John husbandman 627571 627571 Marten, John, of Gaddesby, husbandman 0
5523705 2512243 2512243 defendant Rederford William chaplain 627571 627571 Rederford, William, of Gaddesby, chaplain 1
5531180 2514266 2514266 defendant Whitehedde John yeoman 627571 627571 Whitehedde, John, of Gaddesby, yeoman 0
5637046 2555536 2555536 defendant Pyne John husbandman 627571 627571 Pyne, John, of Gaddesby, husbandman 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);