names

94 rows where place_id = 593234

✎ 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
3611000 1871118 1871118 defendant Estley Henry husbandman 593234 593234 Estley, Henry, of Bratton, husbandman 1
3697842 1925545 1925545 defendant Sterkey Henry clerk 593234 593234 Sterkey, Henry, of Bratton, clerk 0
3698244 1925674 1925674 defendant Hokday Robert husbandman 593234 593234 Hokday, Robert, of Bratton, husbandman 0
3708932 1929085 1929085 defendant Upright Walter husbandman 593234 593234 Upright, Walter, of Bratton, husbandman 0
3728945 1935299 1935299 defendant Wheteacre Richard clothier 593234 593234 Wheteacre, Richard, of Bratton, clothier 0
3729041 1935332 1935332 defendant Knave John butcher 593234 593234 Knave, John, of Bratton, butcher 0
3748277 1941389 1941389 defendant Gyftlake or Eystlake Henry husbandman 593234 593234 Gyftlake or Eystlake, Henry, of Bratton, husbandman 0
3748278 1941389 1941389 defendant Chaston John husbandman 593234 593234 Chaston, John, of Bratton, husbandman 1
3766144 1947063 1947063 defendant Cornedon Henry husbandman 593234 593234 Cornedon, Henry, of Bratton, husbandman 0
3766148 1947064 1947064 defendant Cornedon Henry husbandman 593234 593234 Cornedon, Henry, of Bratton, husbandman 1
3784095 1952807 1952807 defendant Cornedon Henry husbandman 593234 593234 Cornedon, Henry, of Bratton, husbandman 1
3828301 1966727 1966727 defendant Burneby alias Burnabery John gent 593234 593234 Burneby alias Burnabery, John, of Bratton, gent 0
3829126 1966991 1966991 defendant Corndon Henry husbandman 593234 593234 Corndon, Henry, of Bratton, husbandman 0
3829131 1966993 1966993 plaintiff Cornedon Henry   593234 593234 Cornedon, Henry, of Bratton 0
3842719 1971255 1971255 defendant Gale John husbandman 593234 593234 Gale, John, of Bratton, husbandman 0
3853353 1974673 1974673 plaintiff Smyth Edmund clerk 593234 593234 Smyth, Edmund, of Bratton, clerk 0
3900632 1990442 1990442 defendant Cranbury Robert husbandman 593234 593234 Cranbury, Robert, of Bratton, husbandman 0
3914533 1995205 1995205 defendant Crambury Robert husbandman 593234 593234 Crambury, Robert, of Bratton, husbandman 0
3935380 2002145 2002145 defendant Russell Simon husbandman 593234 593234 Russell, Simon, of Bratton, husbandman 2
3935690 2002245 2002245 defendant Downe William husbandman 593234 593234 Downe, William, of Bratton, husbandman 0
3935691 2002245 2002245 defendant Down Thomas husbandman 593234 593234 Down, Thomas, of Bratton, husbandman 1
3944790 2005277 2005277 defendant Dillon Richard gent 593234 593234 Dillon, Richard, of Bratton, gent 0
3954429 2008618 2008618 defendant Buckett Richard husbandman 593234 593234 Buckett, Richard, of Bratton, husbandman 0
3954430 2008618 2008618 defendant Tuell Thomas husbandman 593234 593234 Tuell, Thomas, of Bratton, husbandman 1
3980362 2017746 2017746 defendant Nycoll Agnes widow 593234 593234 Nycoll, Agnes, of Bratton, widow 1
3980363 2017746 2017746 defendant Hockedays Richard husbandman 593234 593234 Hockedays, Richard, of Bratton, husbandman 2
4017308 2030897 2030897 defendant Slowleigh Simon yeoman 593234 593234 Slowleigh, Simon, of Bratton, yeoman 0
4017309 2030897 2030897 defendant Slowleigh John yeoman 593234 593234 Slowleigh, John, of Bratton, yeoman 1
4045641 2040893 2040893 defendant Sperman John husbandman 593234 593234 Sperman, John, of Bratton, husbandman 0
4047216 2041453 2041453 defendant Sperman John husbandman 593234 593234 Sperman, John, of Bratton, husbandman 0
4051195 2042865 2042865 defendant Whyte Olivia widow 593234 593234 Whyte, Olivia, of Bratton, widow 0
4061652 2046564 2046564 defendant Burnburye Richard gent 593234 593234 Burnburye, Richard, of Bratton, gent 0
4147454 2077250 2077250 defendant Sperman William husbandman 593234 593234 Sperman, William, of Bratton, husbandman 1
4209668 2098933 2098933 defendant Langesford Mathew gent 593234 593234 Langesford, Mathew, of Bratton, gent 0
4234715 2107688 2107688 defendant Hales Thomas husbandman 593234 593234 Hales, Thomas, of Bratton, husbandman 0
4302571 2131017 2131017 defendant Boskowen Thomas husbandman 593234 593234 Boskowen, Thomas, of Bratton, husbandman 0
4345159 2145581 2145581 defendant Sherwood Thomas (legal representative) 593234 593234 Sherwood, Thomas, of Bratton, yeoman, executor of 0
4347430 2146357 2146357 defendant Wodder Anthony husbandman 593234 593234 Wodder, Anthony, of Bratton, husbandman 0
4347431 2146357 2146357 defendant Hales Thomas husbandman 593234 593234 Hales, Thomas, of Bratton, husbandman 1
4356761 2149593 2149593 defendant Ballard Timothy husbandman 593234 593234 Ballard, Timothy, of Bratton, husbandman 0
4356762 2149593 2149593 defendant Ballard Roger husbandman 593234 593234 together with Ballard, Roger, of Bratton, husbandman 1
4359250 2150470 2150470 defendant Woodward Anthony husbandman 593234 593234 Woodward, Anthony, of Bratton, husbandman 0
4381011 2158325 2158325 defendant Ballard Roger husbandman 593234 593234 Ballard, Roger, of Bratton, husbandman 0
4381012 2158325 2158325 defendant Ballard Timothy husbandman 593234 593234 Ballard, Timothy, of Bratton, husbandman 1
4402387 2165386 2165386 defendant Newton Thomas yeoman 593234 593234 Newton, Thomas, of Bratton, yeoman 0
4521061 2206926 2206926 defendant Wotton William   593234 593234 Wotton, William, of Bratton 2
4563783 2220242 2220242 defendant Goukyn Thomas   593234 593234 Goukyn, Thomas, of Bratton 2
4652533 2246745 2246745 defendant Bratton Thomas esq 593234 593234 Bratton, Thomas, of Bratton, esq 0
4687049 2261556 2261556 defendant Beare Thomas husbandman 593234 593234 Beare, Thomas, of Bratton, husbandman 0
4692934 2263299 2263299 defendant Bratton Thomas esq 593234 593234 Bratton, Thomas, of Bratton, esq 0
4720297 2271692 2271692 defendant Bratton Edith widow & formerly wife of Nicholas 593234 593234 Bratton, Edith, of Bratton, widow & formerly wife of Nicholas 0
4763511 2284570 2284570 defendant Beaumount Mathew husbandman 593234 593234 Beaumount, Mathew, of Bratton, husbandman 0
4770192 2286649 2286649 defendant West Thomas husbandman 593234 593234 West, Thomas, of Bratton, husbandman 1
4774258 2287932 2287932 defendant atte Nasshe William husbandman 593234 593234 atte Nasshe, William, of Bratton, husbandman 0
4794812 2294521 2294521 defendant West Thomas husbandman 593234 593234 West, Thomas, of Bratton, husbandman 1
4809811 2299231 2299231 defendant Wheler Philip   593234 593234 Wheler, Philip, of Bratton, shepherd 0
4809812 2299231 2299231 defendant Alrugge Robert laborer 593234 593234 Alrugge, Robert, of Bratton, laborer 1
4916067 2331525 2331525 defendant Wakyn John husbandman 593234 593234 Wakyn, John, of Bratton, husbandman 0
4924471 2334091 2334091 defendant Charde William husbandman 593234 593234 Charde, William, of Bratton, husbandman 2
4967729 2347292 2347292 defendant Vysake John, senior husbandman 593234 593234 Vysake, John, senior, of Bratton, husbandman 1
5001195 2357230 2357230 defendant Cranbury Robert   593234 593234 Cranbury, Robert, of Bratton, franklin 0
5003710 2357978 2357978 defendant Hockeday Thomas husbandman 593234 593234 Hockeday, Thomas, of Bratton, husbandman 1
5026360 2364598 2364598 defendant More Thomas tucker 593234 593234 More, Thomas, of Bratton, tucker 2
5030239 2365713 2365713 defendant Hockeday Thomas husbandman 593234 593234 Hockeday, Thomas, of Bratton, husbandman 2
5046330 2370537 2370537 defendant Shilston John gent 593234 593234 Shilston, John, of Bratton, gent 1
5053022 2372501 2372501 defendant Cranbury Robert gent 593234 593234 Cranbury, Robert, of Bratton, gent 0
5053023 2372501 2372501 defendant Cranbury John husbandman 593234 593234 Cranbury, John, of Bratton, husbandman 1
5060265 2374640 2374640 defendant Cranbury Robert gent 593234 593234 Cranbury, Robert, of Bratton, gent 1
5064051 2375782 2375782 defendant Pryns Richard husbandman 593234 593234 Pryns, Richard, of Bratton, husbandman 2
5224289 2422777 2422777 defendant Prynce Richard husbandman 593234 593234 Prynce, Richard, of Bratton, husbandman 1
5228693 2424001 2424001 defendant Charde Rchard butcher 593234 593234 Charde, Rchard, of Bratton, butcher 0
5253386 2431162 2431162 defendant Wonnecote John husbandman 593234 593234 Wonnecote, John, of Bratton, husbandman 0
5264875 2434774 2434774 defendant Cranbury Robert   593234 593234 Cranbury, Robert, of Bratton, millward 0
5264877 2434774 2434774 defendant Cranbury John husbandman 593234 593234 Cranbury, John, of Bratton, husbandman 2
5285887 2440888 2440888 defendant Coryndon Henry yeoman 593234 593234 Coryndon, Henry, of Bratton, yeoman 4
5304650 2446392 2446392 defendant Cranbury William husbandman 593234 593234 Cranbury, William, of Bratton, husbandman 0
5322999 2451953 2451953 defendant Broun John husbandman 593234 593234 Broun, John, of Bratton, husbandman 0
5353005 2461028 2461028 defendant Cranbury John yeoman 593234 593234 Cranbury, John, of Bratton, or of Wyrkyshill, yeoman 0
5456138 2491752 2491752 defendant Passemere John husbandman 593234 593234 Passemere, John, of Bratton, husbandman 3
5458473 2492424 2492424 defendant Barker John clerk 593234 593234 Barker, John, of Bratton, clerk 0
5467948 2495357 2495357 defendant Passemere John husbandman 593234 593234 Passemere, John, of Bratton, husbandman 3
5470106 2495973 2495973 defendant Barker John clerk 593234 593234 Barker, John, of Bratton, clerk 0
5492558 2502688 2502688 defendant Burgh John husbandman 593234 593234 Burgh, John, of Bratton, husbandman 0
5507013 2507107 2507107 defendant Langkeford John husbandman 593234 593234 Langkeford, John,of Bratton, husbandman 3
5536390 2515870 2515870 defendant Bratton Nicholas esq 593234 593234 Bratton, Nicholas, of Bratton, esq 0
5571168 2526131 2526131 defendant Burneby John gent 593234 593234 Burneby, John, of Bratton, gent 1
5571169 2526131 2526131 defendant Estlake Henry gent 593234 593234 Estlake, Henry, of Bratton, gent 2
5571173 2526132 2526132 defendant Burneby John gent 593234 593234 Burneby, John, of Bratton, gent 1
5571174 2526132 2526132 defendant Estlake Henry yeoman 593234 593234 Estlake, Henry, of Bratton, yeoman 2
5571175 2526132 2526132 defendant Ruder John yeoman 593234 593234 Ruder, John, of Bratton, yeoman 3
5571177 2526132 2526132 defendant Estlake John yeoman 593234 593234 Estlake, John, of Bratton, yeoman 5
5581726 2529363 2529363 defendant Grybbyll Walter husbandman 593234 593234 Grybbyll, Walter, of Bratton, husbandman 0
5597336 2534073 2534073 defendant Grybbyll Walter husbandman 593234 593234 Grybbyll, Walter, of Bratton, husbandman 0
5601820 2535470 2535470 defendant Heddon Joan widow 593234 593234 Heddon, Joan, of Bratton, widow 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);