names

73 rows where place_id = 620357

✎ 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
3735261 1937263 1937263 plaintiff Hamond Thomas, senior   620357 620357 Hamond, Thomas, senior, of Wychyngham St Mary 0
3781627 1951991 1951991 defendant Frary William   620357 620357 Frary, William, of Wychyngham St Mary, worsted weaver 0
3781628 1951991 1951991 defendant Frary Ralph   620357 620357 Frary, Ralph, of Wychyngham St Mary, ploughwright 1
3798113 1957307 1957307 plaintiff Hamond Thomas, senior   620357 620357 Hamond, Thomas, senior, of Wychyngham St Mary 0
3885548 1985420 1985420 defendant Frary John singleman 620357 620357 Frary, John, of Wychyngham St Mary, singleman 0
3885549 1985420 1985420 defendant Frary Richard husbandman 620357 620357 Frary, Richard, of Wychyngham St Mary, husbandman 1
3904237 1991662 1991662 defendant Rysyng John   620357 620357 Rysyng, John, of Wychyngham St Mary, bone setter 0
3904243 1991664 1991664 defendant Frarye Nicholas   620357 620357 Frarye, Nicholas, of Wychyngham St Mary, worsted weaver 2
3913340 1994796 1994796 defendant Frary John husbandman 620357 620357 Frary, John, of Wychyngham St Mary, husbandman 0
3921971 1997692 1997692 defendant Becher Richard carpenter 620357 620357 Becher, Richard, of Wychyngham St Mary, carpenter 0
3933128 2001371 2001371 defendant Allens Richard yeoman 620357 620357 Allens, Richard, of Wychyngham St Mary, yeoman 0
4432357 2174901 2174901 plaintiff Cote Robert de (legal representative) 620357 620357 Cote, Robert de, of Wychyngham St Mary, executor of 0
4432358 2174901 2174901 plaintiff Cote John de   620357 620357 Cote, John de, of Wychyngham St Mary 1
4447896 2184269 2184269 defendant Osbern Walter   620357 620357 Osbern, Walter, of Wychyngham St Mary 2
4598032 2230639 2230639 defendant Bakoun Helen   620357 620357 Bakoun, Helen, of Wychyngham St Mary, formerly wife of Walter 1
4598033 2230639 2230639 defendant Balterys John   620357 620357 Balterys, John, of Wychyngham St Mary 2
4650645 2246206 2246206 defendant Bryghtmere William   620357 620357 Bryghtmere, William, of Wychyngham St Mary 6
4801676 2296707 2296707 defendant Feltewell Thomas yeoman 620357 620357 Feltewell, Thomas, of Wychyngham St Mary, yeoman 0
4801677 2296707 2296707 defendant Midelton William husbandman 620357 620357 Midelton, William, of Wychyngham St Mary, husbandman 1
4824215 2303643 2303643 defendant Trewode Alan chapman 620357 620357 Trewode, Alan, of Wychyngham St Mary, chapman 0
4836940 2307511 2307511 plaintiff Feltewell Thomas   620357 620357 Feltewell, Thomas, of Wychyngham St Mary 0
4836941 2307511 2307511 defendant Nene Thomas yeoman 620357 620357 Nene, Thomas, of Wychyngham St Mary, yeoman 0
4892227 2324312 2324312 defendant Wegge John husbandman 620357 620357 Wegge, John, of Wychyngham St Mary, husbandman 4
4892231 2324312 2324312 defendant Wykkes Thomas husbandman 620357 620357 Wykkes, Thomas, of Wychyngham St Mary, husbandman 8
4932912 2336683 2336683 defendant Belagh Richard husbandman 620357 620357 Belagh, Richard, of Wychyngham St Mary, husbandman 2
4932920 2336685 2336685 defendant Bokenham Edmund laborer 620357 620357 Bokenham, Edmund, of Wychyngham St Mary, laborer 0
4961074 2345275 2345275 defendant Wegge Thomas husbandman 620357 620357 Wegge, Thomas, of Wychyngham St Mary, husbandman 0
4961085 2345278 2345278 plaintiff Berney John   620357 620357 Berney, John, of Wychyngham St Mary 0
4964447 2346277 2346277 defendant Byllyott John laborer 620357 620357 Byllyott, John, of Wychyngham St Mary, laborer 1
4965822 2346708 2346708 defendant Sweyn Henry clerk 620357 620357 Sweyn, Henry, of Wychyngham St Mary, clerk 1
5025631 2364405 2364405 defendant Berney John esq 620357 620357 Berney, John, of Wychyngham St Mary, esq 0
5029705 2365558 2365558 defendant Berney John esq 620357 620357 Berney, John, of Wychyngham St Mary, esq 0
5031529 2366081 2366081 defendant Fletwell Robert husbandman 620357 620357 Fletwell, Robert, of Wychyngham St Mary, husbandman 2
5035172 2367151 2367151 defendant Wegge Thomas husbandman 620357 620357 (Wegge, Thomas, of Wychyngham St Mary, husbandman 1
5037833 2367943 2367943 defendant Berneye John esq 620357 620357 Berneye, John, of Wychyngham St Mary, esq 0
5037836 2367943 2367943 defendant Wegge Robert husbandman 620357 620357 Wegge, Robert, of Wychyngham St Mary, husbandman 3
5039413 2368434 2368434 defendant Belyet John husbandman 620357 620357 Belyet, John, of Wychyngham St Mary, husbandman 0
5039415 2368435 2368435 defendant Belyot John husbandman 620357 620357 Belyot, John, of Wychyngham St Mary, husbandman 0
5049065 2371354 2371354 defendant Wegge Thomas husbandman 620357 620357 Wegge, Thomas, of Wychyngham St Mary, husbandman 2
5051746 2372133 2372133 defendant Wegge John husbandman 620357 620357 Wegge, John, of Wychyngham St Mary, husbandman 2
5054189 2372847 2372847 defendant Wykkys Thomas husbandman 620357 620357 Wykkys, Thomas, of Wychyngham St Mary, husbandman 0
5070431 2377649 2377649 defendant Belyot John yeoman 620357 620357 Belyot, John, of Wychyngham St Mary, yeoman 0
5070584 2377697 2377697 defendant Wegge Thomas husbandman 620357 620357 Wegge, Thomas, of Wychyngham St Mary, husbandman 2
5071302 2377912 2377912 defendant Belyot John husbandman 620357 620357 Belyot, John, of Wychyngham St Mary, husbandman 2
5071331 2377920 2377920 defendant Torell Thomas carpenter 620357 620357 Torell, Thomas, of Wychyngham St Mary, carpenter 0
5071332 2377920 2377920 defendant Momerey John, senior husbandman 620357 620357 Momerey, John, senior, of Wychyngham St Mary, husbandman 1
5071333 2377920 2377920 defendant Momerey John, junior laborer 620357 620357 Momerey, John, junior, of Wychyngham St Mary, laborer 2
5071335 2377920 2377920 defendant Gronde John yeoman 620357 620357 Gronde, John, of Wychyngham St Mary, yeoman 4
5072436 2378244 2378244 defendant Wegge Thomas yeoman 620357 620357 Wegge, Thomas,of Wychyngham St Mary, yeoman 1
5072983 2378408 2378408 defendant Berney John esq 620357 620357 Berney, John, of Wychyngham St Mary, esq 0
5072985 2378408 2378408 defendant Whight Thomas husbandman 620357 620357 Whight, Thomas, of Wychyngham St Mary, husbandman 2
5072987 2378409 2378409 defendant Berney John esq 620357 620357 Berney, John, of Wychyngham St Mary, esq 0
5072988 2378409 2378409 defendant Gronde John   620357 620357 Gronde, John, of Wychyngham St Mary, servant 1
5072989 2378409 2378409 defendant Whight Thomas husbandman 620357 620357 Whight, Thomas, of Wychyngham St Mary, husbandman 2
5090918 2383738 2383738 defendant Belyet John husbandman 620357 620357 Belyet, John, of Wychyngham St Mary, husbandman 0
5093151 2384388 2384388 defendant Neve Thomas husbandman 620357 620357 Neve, Thomas, of Wychyngham St Mary, husbandman 0
5100246 2386515 2386515 defendant Broom alias Broun Thomas husbandman 620357 620357 Broom alias Broun, Thomas, of Wychyngham St Mary, husbandman 1
5100355 2386545 2386545 defendant Broun Thomas husbandman 620357 620357 Broun, Thomas, of Wychyngham St Mary, husbandman 12
5107556 2388641 2388641 plaintiff Dounyng Thomas   620357 620357 Dounyng, Thomas, of Wychyngham St Mary 0
5109973 2389346 2389346 defendant Berney John gent 620357 620357 Berney, John, of Wychyngham St Mary, gent 0
5119301 2392067 2392067 defendant Belyet John yeoman 620357 620357 Belyet, John, of Wychyngham St Mary, yeoman 1
5123213 2393226 2393226 defendant Belyet John yeoman 620357 620357 Belyet, John, of Wychyngham St Mary, yeoman 0
5126085 2394112 2394112 defendant Cok Thomas   620357 620357 Cok, Thomas, of Wychyngham St Mary 2
5230415 2424510 2424510 plaintiff Barbour William   620357 620357 Barbour, William, of Wychyngham St Mary 0
5230416 2424510 2424510 defendant Broun Thomas husbandman 620357 620357 Broun, Thomas, of Wychyngham St Mary, husbandman 0
5249018 2429836 2429836 defendant Caly Richard husbandman 620357 620357 Caly, Richard, of Wychyngham St Mary, husbandman 1
5278571 2438842 2438842 defendant Frany or Fravy Simon husbandman 620357 620357 Frany or Fravy, Simon, of Wychyngham St Mary, husbandman 0
5294224 2443281 2443281 defendant Baken John husbandman 620357 620357 Baken, John, of Wychyngham St Mary, husbandman 1
5308717 2447644 2447644 defendant Dey Richard miller 620357 620357 Dey, Richard, of Wychyngham St Mary, miller 3
5440327 2487005 2487005 defendant Est Peter yeoman 620357 620357 Est, Peter, of Wychyngham St Mary, yeoman 15
5548570 2519622 2519622 defendant Frary Richard   620357 620357 Frary, Richard, of Wychyngham St Mary, ploughwright 0
5553094 2520943 2520943 defendant Childe Thomas yeoman 620357 620357 Childe, Thomas, of Wychyngham St Mary, yeoman 1
5553095 2520943 2520943 defendant Childe John yeoman 620357 620357 Childe, John, of Wychyngham St Mary, yeoman 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);