names

100 rows where place_id = 598220

✎ 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
3631617 1904703 1904703 defendant Palle John tailor 598220 598220 Palle, John, of Halesworth, tailor 0
3845367 1972111 1972111 defendant Hopton Thomas butcher 598220 598220 Hopton, Thomas, of Halesworth, butcher 1
4029164 2035074 2035074 defendant Waynflete John yeoman 598220 598220 Waynflete, John, of Halesworth, yeoman 1
4029167 2035075 2035075 defendant Waynflete John yeoman 598220 598220 Waynflete, John, of Halesworth, yeoman 1
4426614 2173135 2173135 plaintiff Payn Geoffrey   598220 598220 Payn, Geoffrey, of Halesworth 0
4426617 2173136 2173136 plaintiff Payn Geoffrey   598220 598220 Payn, Geoffrey, of Halesworth 0
4505442 2202231 2202231 defendant Baron Robert   598220 598220 Baron, Robert, of Halesworth 0
4548924 2215595 2215595 defendant Kyng John   598220 598220 Kyng, John, of Halesworth 1
4548929 2215596 2215596 defendant Kyng John   598220 598220 Kyng, John, of Halesworth 1
4592339 2228951 2228951 defendant Yonge John   598220 598220 Yonge, John, of Halesworth 2
4651222 2246388 2246388 defendant Argenten William   598220 598220 Argenten, William, of Halesworth, knight 0
4681532 2259835 2259835 defendant Smith Alexander smith 598220 598220 Smith, Alexander, of Halesworth, smith 2
4717129 2270685 2270685 defendant Nygell John thatcher 598220 598220 Nygell, John, of Halesworth, thatcher 0
4717134 2270686 2270686 defendant Nygell John thatcher 598220 598220 Nygell, John, of Halesworth, thatcher 0
4723620 2272693 2272693 plaintiff Dobbes John   598220 598220 Dobbes, John, of Halesworth 0
4724906 2273082 2273082 defendant Caudeler William   598220 598220 Caudeler, William, of Halesworth, bailiff 0
4795747 2294821 2294821 defendant Hunne Thomas   598220 598220 Hunne, Thomas, of Halesworth, wright 0
4824090 2303608 2303608 defendant Elmy William yeoman 598220 598220 Elmy, William, of Halesworth, yeoman 1
4834822 2306894 2306894 defendant Meke Robert yeoman 598220 598220 Meke, Robert, of Halesworth, yeoman 0
4841724 2308949 2308949 defendant Sparhauk William butcher 598220 598220 Sparhauk, William, of Halesworth, butcher 0
4899511 2326485 2326485 defendant Sparhauk William butcher 598220 598220 Sparhauk, William, of Halesworth, butcher 4
4928206 2335250 2335250 defendant Smyth Alexander (legal representative) 598220 598220 Smyth, Alexander, of Halesworth, executors of 2
4972050 2348576 2348576 defendant Troket Thomas cordwainer 598220 598220 Troket, Thomas, of Halesworth, cordwainer 1
4974058 2349204 2349204 defendant Haule or Hanle John barber 598220 598220 Haule or Hanle, John, of Halesworth, barber 1
4986806 2352992 2352992 defendant Palmere Thomas weaver 598220 598220 Palmere, Thomas, of Halesworth, weaver 3
4989585 2353816 2353816 defendant Barker Thomas tanner 598220 598220 Barker, Thomas, of Halesworth, tanner 2
4997759 2356186 2356186 defendant Randolf William yeoman 598220 598220 Randolf, William, of Halesworth, yeoman 0
5002593 2357670 2357670 defendant Sperhauk William butcher 598220 598220 Sperhauk, William, of Halesworth, butcher 0
5005771 2358585 2358585 defendant Brook Richard husbandman 598220 598220 Brook, Richard, of Halesworth, husbandman 1
5005772 2358585 2358585 defendant Fyn John husbandman 598220 598220 Fyn, John, of Halesworth, husbandman 2
5007289 2359025 2359025 defendant Mounford Richard engraver 598220 598220 Mounford, Richard, of Halesworth, engraver 0
5023055 2363649 2363649 defendant Dentard John butcher 598220 598220 Dentard, John, of Halesworth, butcher 2
5040699 2368830 2368830 defendant Wynne William dyer 598220 598220 Wynne, William, of Halesworth, dyer 1
5043449 2369664 2369664 defendant Palmere Thomas husbandman 598220 598220 Palmere, Thomas, of Halesworth, husbandman 0
5051079 2371930 2371930 defendant Ro William husbandman 598220 598220 Ro, William, of Halesworth, husbandman 3
5051406 2372037 2372037 defendant Goche Richard butcher 598220 598220 Goche, Richard, of Halesworth, butcher 1
5055762 2373294 2373294 defendant Dentard Adam husbandman 598220 598220 Dentard, Adam, of Halesworth, husbandman 1
5055766 2373295 2373295 defendant Dentard Adam husbandman 598220 598220 Dentard, Adam, of Halesworth, husbandman 2
5068954 2377211 2377211 defendant Wysk William barker 598220 598220 Wysk, William, of Halesworth, barker 3
5090156 2383494 2383494 defendant Broke Richard mercer 598220 598220 Broke, Richard, of Halesworth, mercer 0
5097711 2385755 2385755 defendant Ledere Richard butcher 598220 598220 Ledere, Richard, of Halesworth, butcher 0
5102009 2387011 2387011 defendant Wyske William barker 598220 598220 Wyske, William, of Halesworth, barker 0
5105534 2388066 2388066 defendant Power John engraver 598220 598220 Power, John, of Halesworth, engraver 0
5105535 2388066 2388066 defendant Castelacre Richard engraver 598220 598220 Castelacre, Richard, of Halesworth, engraver 1
5122987 2393153 2393153 defendant Randolf Robert yeoman 598220 598220 Randolf, Robert, of Halesworth, yeoman 0
5122988 2393153 2393153 defendant Palmere Thomas yeoman 598220 598220 Palmere, Thomas, of Halesworth, yeoman 1
5123014 2393161 2393161 defendant Baret Geoffrey turner 598220 598220 Baret, Geoffrey, of Halesworth, turner 1
5141951 2398765 2398765 defendant Palmere Thomas yeoman 598220 598220 Palmere, Thomas, of Halesworth, yeoman 2
5141952 2398765 2398765 defendant Randolf Robert yeoman 598220 598220 Randolf, Robert, of Halesworth, yeoman 3
5161486 2404459 2404459 defendant Ederych John butcher 598220 598220 Ederych, John, of Halesworth, butcher 2
5163035 2404915 2404915 defendant Palmere Thomas yeoman 598220 598220 Palmere, Thomas, of Halesworth, yeoman 1
5163037 2404915 2404915 defendant Randolf Robert yeoman 598220 598220 Randolf, Robert, of Halesworth, yeoman 3
5167888 2406320 2406320 defendant Dentard Adam husbandman 598220 598220 Dentard, Adam, of Halesworth, husbandman 0
5175019 2408388 2408388 defendant Keswyk John husbandman 598220 598220 Keswyk, John, of Halesworth, husbandman 0
5175876 2408626 2408626 defendant Ederych John butcher 598220 598220 Ederych, John, of Halesworth, butcher 2
5183570 2410931 2410931 defendant Dentard Adam husbandman 598220 598220 Dentard, Adam, of Halesworth, husbandman 0
5183575 2410932 2410932 defendant Dentard Adam husbandman 598220 598220 Dentard, Adam, of Halesworth, husbandman 0
5183580 2410933 2410933 defendant Dentard Adam husbandman 598220 598220 Dentard, Adam, of Halesworth, husbandman 0
5186136 2411695 2411695 defendant Dunmowe Nicholas barber 598220 598220 Dunmowe, Nicholas, of Halesworth, barber 0
5196014 2414582 2414582 defendant Keswyk John husbandman 598220 598220 Keswyk, John, of Halesworth, husbandman 0
5196018 2414583 2414583 defendant Keswyk John husbandman 598220 598220 Keswyk, John, of Halesworth, husbandman 0
5196164 2414624 2414624 defendant Keswyk John husbandman 598220 598220 Keswyk, John, of Halesworth, husbandman 0
5197520 2415014 2415014 defendant Gerych John butcher 598220 598220 Gerych, John, of Halesworth, butcher 2
5197529 2415016 2415016 defendant Ederych John butcher 598220 598220 Ederych, John, of Halesworth, butcher 2
5199335 2415554 2415554 defendant Dryver William baker 598220 598220 Dryver, William, of Halesworth, baker 3
5203918 2416898 2416898 defendant Dentard Adam husbandman 598220 598220 Dentard, Adam, of Halesworth, husbandman 0
5209482 2418513 2418513 defendant Keswyk John husbandman 598220 598220 Keswyk, John, of Halesworth, husbandman 0
5211079 2418968 2418968 defendant Dryver William baker 598220 598220 Dryver, William, of Halesworth, baker 2
5211087 2418969 2418969 defendant Dryver William baker 598220 598220 Dryver, William, of Halesworth, baker 3
5220395 2421660 2421660 defendant Flecher William baker 598220 598220 Flecher, William, of Halesworth, baker 2
5220399 2421661 2421661 defendant Flecher William baker 598220 598220 Flecher, William, of Halesworth, baker 2
5221828 2422082 2422082 defendant Parke Isabel widow 598220 598220 Parke, Isabel, of Halesworth, widow 1
5224653 2422881 2422881 plaintiff Randolf Robert draper 598220 598220 Randolf, Robert, of Halesworth, draper 0
5224658 2422882 2422882 plaintiff Randolf Robert   598220 598220 Randolf, Robert,of Halesworth 0
5224659 2422882 2422882 defendant Mapulbek Robert mercer 598220 598220 Mapulbek, Robert, of Halesworth, mercer 0
5225616 2423165 2423165 defendant Roo William husbandman 598220 598220 Roo, William, of Halesworth, husbandman 0
5225618 2423165 2423165 defendant Roo Walter merchant 598220 598220 Roo, Walter, of Halesworth, merchant 2
5225620 2423165 2423165 defendant Brook John chapman 598220 598220 Brook, John, of Halesworth, chapman 4
5233561 2425408 2425408 defendant Keswik John pedder 598220 598220 Keswik, John, of Halesworth, pedder 1
5236048 2426127 2426127 defendant Brook Richard mercer 598220 598220 Brook, Richard, of Halesworth, mercer 0
5239671 2427190 2427190 defendant Randolf Robert draper 598220 598220 Randolf, Robert, of halesworth, draper 0
5246780 2429221 2429221 defendant Kesewik John husbandman 598220 598220 Kesewik, John, of Halesworth, husbandman 0
5262552 2434030 2434030 defendant Palmer Robert carpenter 598220 598220 Palmer, Robert, of Halesworth, carpenter 0
5265848 2435071 2435071 defendant Turnour Robert yeoman 598220 598220 Turnour, Robert, of Halesworth, yeoman 0
5273800 2437416 2437416 plaintiff Turnour Robert   598220 598220 Turnour, Robert, of Halesworth 5
5278818 2438913 2438913 defendant Freman Robert yeoman 598220 598220 Freman, Robert, of Halesworth, yeoman 0
5288031 2441515 2441515 defendant Goderych William butcher 598220 598220 Goderych, William, of Halesworth, butcher 0
5288033 2441515 2441515 defendant Goderych Richard butcher 598220 598220 Goderych, Richard, of Halesworth, butcher 2
5294956 2443515 2443515 defendant Sewale Robert mercer 598220 598220 Sewale, Robert, of Halesworth, mercer 3
5309688 2447934 2447934 defendant Roo Joan widow 598220 598220 Roo, Joan, of Halesworth, widow 0
5322296 2451739 2451739 defendant Roo Walter (legal representative) 598220 598220 Roo, Walter, of Halesworth, merchant, administrator of 2
5322297 2451739 2451739 defendant Roo William yeoman 598220 598220 Roo, William, of Halesworth, yeoman 3
5329756 2453973 2453973 defendant Goderyche Richard butcher 598220 598220 Goderyche, Richard, of Halesworth, butcher 0
5337241 2456208 2456208 defendant Bakke Bartholomew yeoman 598220 598220 Bakke, Bartholomew, of Halesworth, yeoman 0
5342685 2457913 2457913 defendant Dunmowe Roger mercer 598220 598220 Dunmowe, Roger, of Halesworth, mercer 0
5372522 2467004 2467004 defendant Stroder John tailor 598220 598220 Stroder, John, of Halesworth, tailor 0
5438201 2486359 2486359 defendant Abbot William sherman 598220 598220 Abbot, William, of Halesworth, sherman 1
5452319 2490566 2490566 defendant Abbot William sherman 598220 598220 Abbot, William, of Halesworth, sherman 1
5461422 2493369 2493369 defendant Godryche William butcher 598220 598220 Godryche, William, of Halesworth, butcher 0
5629681 2553274 2553274 defendant Crispyng Roger husbandman 598220 598220 Crispyng, Roger, of Halesworth, husbandman 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);