names

99 rows where place_id = 587592

✎ 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
3591859 1865074 1865074 defendant Fysshe Robert baker 587592 587592 Fysshe, Robert, of Hempton, baker 3
3593482 1865596 1865596 defendant Fysshe Robert baker 587592 587592 Fysshe, Robert, of Hempton, baker 0
3606266 1869626 1869626 defendant Deen Thomas innholder 587592 587592 Deen, Thomas, of Hempton, innholder 2
3607953 1870137 1870137 plaintiff Smyth alias Baker Richard   587592 587592 Smyth alias Baker, Richard, of Hempton 0
3623637 1874925 1874925 plaintiff Smyth alias Baxster Richard   587592 587592 Smyth alias Baxster, Richard, of Hempton 0
3658499 1912910 1912910 plaintiff (not given) William prior of Fakenham 587592 587592 Fakenham, William, of Hempton, prior of the Monastery of St Mary 0
3699304 1925997 1925997 defendant Smyth John husbandman 587592 587592 Smyth, John, of Hempton, husbandman 3
3702683 1927109 1927109 defendant Rose Robert laborer 587592 587592 Rose, Robert, of Hempton, laborer 1
3755043 1943527 1943527 defendant Chapman Robert laborer 587592 587592 Chapman, Robert, of Hempton, laborer 0
3760780 1945374 1945374 defendant Wylkys John husbandman 587592 587592 Wylkys, John, of Hempton, husbandman 0
3768857 1947907 1947907 defendant Wilkys John husbandman 587592 587592 Wilkys, John, of Hempton, husbandman 1
3789425 1954517 1954517 defendant Hoberd Thomas tailor 587592 587592 Hoberd, Thomas, of Hempton, tailor 2
3798426 1957407 1957407 defendant Wylkes John husbandman 587592 587592 Wylkes, John, of Hempton, husbandman 5
3798427 1957407 1957407 defendant Falles Richard husbandman 587592 587592 Falles, Richard, of Hempton, husbandman 6
3837172 1969527 1969527 plaintiff Sheltram Walter beer brewer 587592 587592 Sheltram, Walter, of Hempton, beer brewer 2
3837310 1969579 1969579 plaintiff Smyth James innkeeper 587592 587592 Smyth, James, of Hempton, innkeeper 0
3853366 1974676 1974676 plaintiff Smyth James innkeeper 587592 587592 Smyth, James, of Hempton, innkeeper 0
3890967 1987243 1987243 defendant Dowde Joan widow 587592 587592 Dowde, Joan, of Hempton, widow 0
3912008 1994340 1994340 defendant Salter Henry chaplain 587592 587592 Salter, Henry, of Hempton, chaplain 0
4121774 2068085 2068085 defendant Twid William   587592 587592 Twid, William, of Hempton, sailor 0
4141994 2075372 2075372 defendant Wylkes Humphrey husbandman 587592 587592 Wylkes, Humphrey, of Hempton, husbandman 0
4148954 2077754 2077754 defendant Twid William   587592 587592 Twid, William, of Hempton, sailor 0
4150804 2078415 2078415 defendant Sellars John baker 587592 587592 Sellars, John, of Hempton, baker 2
4165605 2083471 2083471 defendant Wylkes Humphrey husbandman 587592 587592 Wylkes, Humphrey, of Hempton, husbandman 0
4183831 2089839 2089839 defendant Wylson Richard glover 587592 587592 Wylson, Richard, of Hempton, glover 0
4260056 2116330 2116330 defendant Stapleton Thomas yeoman 587592 587592 Stapleton, Thomas, of Hempton, yeoman 1
4302477 2130986 2130986 defendant Tymall Anthony yeoman 587592 587592 Tymall, Anthony, of Hempton, yeoman 0
4302478 2130986 2130986 defendant Jarvys John yeoman 587592 587592 Jarvys, John, of Hempton, yeoman 1
4405032 2166256 2166256 defendant Stapleton Thomas yeoman 587592 587592 Stapleton, Thomas, of Hempton, yeoman 1
4488644 2197169 2197169 defendant Baxtere Alan   587592 587592 Baxtere, Alan, of Hempton 0
4494404 2198946 2198946 defendant Cook John   587592 587592 Cook, John, of Hempton 1
4512469 2204341 2204341 defendant Spencer Richard   587592 587592 Spencer, Richard, of Hempton 1
4566687 2221155 2221155 defendant Maryot Robert   587592 587592 Maryot, Robert, of Hempton 2
4566688 2221155 2221155 defendant Smyth Walter   587592 587592 Smyth, Walter, of Hempton 3
4595906 2229976 2229976 plaintiff Rogers William   587592 587592 Rogers, William, of Hempton 0
4604028 2232428 2232428 defendant Skynner Thomas   587592 587592 Skynner, Thomas, of Hempton 6
4604979 2232718 2232718 defendant Lexham Thomas   587592 587592 Lexham, Thomas, of Hempton 1
4642231 2243846 2243846 defendant Lexham Thomas   587592 587592 Lexham, Thomas, of Hempton 0
4683135 2260339 2260339 defendant Walsham John yeoman 587592 587592 Walsham, John, of Hempton, yeoman 2
4683138 2260340 2260340 defendant Walsham John yeoman 587592 587592 Walsham, John, of Hempton, yeoman 1
4683683 2260498 2260498 defendant Bardolf Walter husbandman 587592 587592 Bardolf, Walter, of Hempton, husbandman 0
4683684 2260498 2260498 defendant Walsham John yeoman 587592 587592 Walsham, John, of Hempton, yeoman 1
4684215 2260665 2260665 defendant Walsham John yeoman 587592 587592 Walsham, John, of Hempton, yeoman 3
4706843 2267518 2267518 defendant Esthall Edmund chapman 587592 587592 Esthall, Edmund, of Hempton, chapman 0
4769265 2286365 2286365 defendant Bardolffe Walter yeoman 587592 587592 Bardolffe, Walter, of Hempton, yeoman 1
4831581 2305911 2305911 plaintiff Broun Thomas   587592 587592 Broun, Thomas, of Hempton 0
4847615 2310745 2310745 plaintiff Rowe John   587592 587592 Rowe, John, of Hempton 0
4858470 2314022 2314022 plaintiff Broun Thomas   587592 587592 Broun, Thomas, of Hempton 0
4863153 2315453 2315453 defendant Frank Nicholas yeoman 587592 587592 Frank, Nicholas, of Hempton, yeoman 4
4865319 2316125 2316125 defendant Randolf Richard yeoman 587592 587592 Randolf, Richard, of Hempton, yeoman 1
4867052 2316659 2316659 defendant Doraunt John husbandman 587592 587592 Doraunt, John, of Hempton, husbandman 1
4881935 2321248 2321248 defendant Meryman Robert husbandman 587592 587592 Meryman, Robert, of Hempton, husbandman 0
4906661 2328670 2328670 defendant Brewyn John yeoman 587592 587592 together with Brewyn, John, of Hempton, yeoman 1
4984751 2352368 2352368 defendant Wylkes Richard husbandman 587592 587592 Wylkes, Richard, of Hempton, husbandman 0
4989077 2353672 2353672 plaintiff Browne Robert   587592 587592 Browne, Robert, of Hempton 0
4996217 2355724 2355724 defendant Doode William husbandman 587592 587592 Doode, William, of Hempton, husbandman 1
5007561 2359107 2359107 defendant Haynes John carpenter 587592 587592 Haynes, John, of Hempton, carpenter 0
5007562 2359107 2359107 defendant Brokle Thomas husbandman 587592 587592 Brokle, Thomas, of Hempton, husbandman 1
5016761 2361793 2361793 defendant Doraunt John husbandman 587592 587592 Doraunt, John, of Hempton, husbandman 1
5028800 2365299 2365299 defendant Whyte William yeoman 587592 587592 Whyte, William, of Hempton, yeoman 2
5028806 2365300 2365300 defendant Whyte William yeoman 587592 587592 Whyte, William, of Hempton, yeoman 3
5040486 2368762 2368762 defendant Neugate William smith 587592 587592 Neugate, William, of Hempton, smith 0
5081028 2380828 2380828 defendant Broun Robert yeoman 587592 587592 Broun, Robert, of Hempton, yeoman 0
5081031 2380829 2380829 defendant Broun Robert yeoman 587592 587592 Broun, Robert, of Hempton, yeoman 0
5085542 2382164 2382164 defendant Broun Robert courser 587592 587592 Broun, Robert, of Hempton, courser 0
5094513 2384803 2384803 defendant Martyn John husbandman 587592 587592 Martyn, John, of Hempton, husbandman 1
5100336 2386544 2386544 defendant Roberdys John pedder 587592 587592 Roberdys, John, of Hempton, pedder 8
5121855 2392824 2392824 defendant Fisshe Robert baker 587592 587592 Fisshe, Robert, of Hempton, baker 3
5277203 2438416 2438416 defendant Fyssh Robert baker 587592 587592 Fyssh, Robert, of Hempton, baker 1
5288652 2441702 2441702 plaintiff Smyth Richard baker 587592 587592 Smyth, Richard, of Hempton, baker 1
5319608 2450958 2450958 defendant Reynolds Edmund husbandman 587592 587592 Reynolds, Edmund, of Hempton, husbandman 2
5331751 2454579 2454579 defendant Fysshe Robert baker 587592 587592 Fysshe, Robert, of Hempton, baker 8
5333462 2455081 2455081 defendant Walwyk Robert yeoman 587592 587592 Walwyk, Robert, of Hempton, yeoman 1
5339655 2456977 2456977 defendant Reynhold Edmund husbandman 587592 587592 Reynhold, Edmund, of Hempton, husbandman 0
5368695 2465801 2465801 defendant Juers Robert husbandman 587592 587592 Juers, Robert, of Hempton, husbandman 0
5368696 2465801 2465801 defendant Baxster Robert husbandman 587592 587592 Baxster, Robert, of Hempton, husbandman 1
5368697 2465801 2465801 defendant Coper William laborer 587592 587592 Coper, William, of Hempton, laborer 2
5406225 2476855 2476855 defendant Chyerdan Roland ostler 587592 587592 Chyerdan, Roland, of Hempton, ostler 0
5406243 2476858 2476858 defendant Walwyk William ostler 587592 587592 Walwyk, William, of Hempton, ostler 3
5419127 2480647 2480647 defendant Fysshe Robert husbandman 587592 587592 Fysshe, Robert, of Hempton, husbandman 4
5419292 2480695 2480695 defendant Welwyk William ostler 587592 587592 Welwyk, William, of Hempton, ostler 3
5437577 2486176 2486176 defendant Walwyk William ostler 587592 587592 Walwyk, William, of Hempton, ostler 2
5437581 2486177 2486177 defendant Walwyk William ostler 587592 587592 Walwyk, William, of Hempton, ostler 2
5474945 2497489 2497489 defendant Brenetour Simon butcher 587592 587592 Brenetour, Simon, of Hempton, butcher 0
5486761 2500942 2500942 defendant Fysshe Robert yeoman 587592 587592 Fysshe, Robert, of Hempton, yeoman 1
5496388 2503825 2503825 plaintiff Ivers Robert   587592 587592 Ivers, Robert, of Hempton 0
5517675 2510366 2510366 defendant Fysshe Robert, junior baker 587592 587592 Fysshe, Robert, junior, of Hempton, baker 0
5530497 2514055 2514055 defendant Dene Thomas husbandman 587592 587592 Dene, Thomas, of Hempton, husbandman 0
5530498 2514055 2514055 defendant Toppys Robert laborer 587592 587592 Toppys, Robert, of Hempton, laborer 1
5531393 2514340 2514340 plaintiff Smyth alias Basxter Richard   587592 587592 Smyth alias Basxter, Richard, of Hempton 0
5531398 2514341 2514341 plaintiff Smyth alias Baxter Richard   587592 587592 Smyth alias Baxter, Richard, of Hempton 0
5531438 2514358 2514358 plaintiff Smyth Richard   587592 587592 Smyth, Richard, of Hempton 0
5539389 2516806 2516806 defendant Fermour John innholder 587592 587592 Fermour, John, of Hempton, innholder 0
5544126 2518277 2518277 defendant Deen Thomas yeoman 587592 587592 Deen, Thomas, of Hempton, yeoman 0
5544131 2518279 2518279 defendant Deem Thomas yeoman 587592 587592 Deem Thomas, of Hempton, yeoman 1
5568295 2525272 2525272 defendant Stubberd John husbandman 587592 587592 Stubberd, John, of Hempton, husbandman 0
5627724 2552639 2552639 defendant Walsham John yeoman 587592 587592 Walsham, John, of Hempton, yeoman 3
5632660 2554233 2554233 defendant Skrevener Walter   587592 587592 Skrevener, Walter, of Hempton 5
5633577 2554495 2554495 defendant Ferrour or Smith Walter barber 587592 587592 Ferrour or Smith, Walter, of Hempton, barber 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);