names

75 rows where place_id = 589487

✎ 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
3597772 1866921 1866921 defendant Baker Nicholas yeoman 589487 589487 Baker, Nicholas, of Folkeston, yeoman 3
3597773 1866921 1866921 defendant Nycoll Robert yeoman 589487 589487 Nycoll, Robert, of Folkeston, yeoman 4
3692314 1923765 1923765 defendant Goldworth William yeoman 589487 589487 Goldworth, William, of Folkeston, yeoman 2
3802724 1958749 1958749 defendant Orgar John laborer 589487 589487 Orgar, John, of Folkeston, laborer 0
3806753 1960012 1960012 defendant Bolte Richard yeoman and brick maker 589487 589487 Bolte, Richard, of Folkeston, yeoman and brick maker 1
3826691 1966196 1966196 defendant Tong Emma widow 589487 589487 Tong, Emma, of Folkeston, widow 0
3826693 1966196 1966196 defendant Morice Thomas fisherman 589487 589487 Morice, Thomas, of Folkeston, fisherman 2
3908605 1993176 1993176 defendant Coulley Richard yeoman 589487 589487 Coulley, Richard, of Folkeston, yeoman 0
3908606 1993176 1993176 defendant Baker Thomas mariner 589487 589487 Baker, Thomas, of Folkeston, mariner 1
3918440 1996495 1996495 defendant Waryner Thomas yeoman 589487 589487 Waryner, Thomas, of Folkeston, yeoman 0
4370029 2154337 2154337 defendant Beane Henry husbandman 589487 589487 Beane, Henry, of Folkeston, husbandman 0
4681520 2259833 2259833 plaintiff Mellere John (legal representative) 589487 589487 Mellere, John, of Folkeston, executor of 0
4684090 2260628 2260628 defendant Hert Thomas farmer 589487 589487 Hert, Thomas, of Folkeston, farmer 0
4817135 2301451 2301451 plaintiff Mellere John (legal representative) 589487 589487 Mellere, John, of Folkeston, executor of 0
4928486 2335334 2335334 plaintiff Smyth John   589487 589487 Smyth, John, of Folkeston 0
4976397 2349903 2349903 defendant Henewode Constance widow 589487 589487 Henewode, Constance, of Folkeston, widow 0
5001010 2357173 2357173 defendant Baker William yeoman 589487 589487 Baker, William, of Folkeston, yeoman 2
5005410 2358482 2358482 defendant Aleyn Richard husbandman 589487 589487 Aleyn, Richard, of Folkeston, husbandman 2
5013138 2360670 2360670 defendant Nolde William laborer 589487 589487 Nolde, William, of Folkeston, laborer 6
5017886 2362116 2362116 defendant Broun John gent 589487 589487 Broun, John, of Folkeston, gent 0
5017888 2362117 2362117 defendant Rykdon Robert mariner 589487 589487 Rykdon, Robert, of Folkeston, mariner 0
5057177 2373725 2373725 defendant Bukley William yeoman 589487 589487 Bukley, William, of Folkeston, yeoman 4
5057181 2373725 2373725 defendant Kays Thomas yeoman 589487 589487 Kays, Thomas, of Folkeston, yeoman 8
5057183 2373725 2373725 defendant Clynton John esq 589487 589487 Clynton, John, of Folkeston, esq 10
5080381 2380625 2380625 defendant Clynton John esq 589487 589487 Clynton, John, of Folkeston, esq 2
5080384 2380625 2380625 defendant Bukley William yeoman 589487 589487 Bukley, William, of Folkeston, yeoman 5
5080388 2380625 2380625 defendant Kays Thomas yeoman 589487 589487 Kays, Thomas, of Folkeston, yeoman 9
5080396 2380626 2380626 defendant Clynton John esq 589487 589487 Clynton, John, of Folkeston, esq 4
5080399 2380626 2380626 defendant Buk- William yeoman 589487 589487 Buk-, William, of Folkeston, yeoman 7
5080403 2380626 2380626 defendant Keys Thomas yeoman 589487 589487 Keys, Thomas, of Folkeston, yeoman 11
5128122 2394699 2394699 defendant Baker William yeoman 589487 589487 Baker, William, of Folkeston, yeoman 0
5128124 2394699 2394699 defendant Goldwort John husbandman 589487 589487 Goldwort, John, of Folkeston, husbandman 2
5147200 2400321 2400321 defendant Baker William yeoman 589487 589487 Baker, William, of Folkeston, yeoman 0
5265930 2435098 2435098 plaintiff Tonge William   589487 589487 Tonge, William, of Folkeston 0
5265932 2435099 2435099 plaintiff Tonge William   589487 589487 Tonge, William, of Folkeston 0
5269051 2436051 2436051 defendant Merston Thomas yeoman 589487 589487 Merston, Thomas, of Folkeston, yeoman 0
5278367 2438781 2438781 defendant Caas Thomas yeoman 589487 589487 Caas, Thomas, of Folkeston, yeoman 0
5278369 2438782 2438782 defendant Caas Thomas yeoman 589487 589487 Caas, Thomas, of Folkeston, yeoman 0
5300050 2444980 2444980 defendant (not given) Thomas prior of Davys or Banys 589487 589487 Davys or Banys, Thomas, of Folkeston, prior of the church of the BM & St Eanswythe, the virgin 1
5310310 2448115 2448115 defendant Baker William yeoman 589487 589487 (Baker, William, of Folkeston, yeoman 1
5335785 2455768 2455768 defendant Bone Thomas husbandman 589487 589487 Bone, Thomas, of Folkeston, husbandman 2
5378097 2468729 2468729 plaintiff Thorold Philip (legal representative) 589487 589487 Thorold, Philip, of Folkeston, executor of 0
5418275 2480393 2480393 defendant Astok Simon husbandman 589487 589487 Astok, Simon, of Folkeston, husbandman 0
5432922 2484815 2484815 defendant Strete William mariner 589487 589487 Strete, William, of Folkeston, mariner 0
5438682 2486504 2486504 plaintiff Thorold Philip (legal representative) 589487 589487 Thorold, Philip, of Folkeston, executors of 0
5438687 2486504 2486504 defendant Jenkyn John fisher 589487 589487 Jenkyn, John, of Folkeston, fisher 0
5438697 2486505 2486505 defendant Jenkyn John fisher 589487 589487 Jenkyn, John, of Folkeston, fisher 0
5443944 2488107 2488107 defendant Taylour William yeoman 589487 589487 Taylour, William, of Folkeston, yeoman 0
5443945 2488107 2488107 defendant Rydon William shipman 589487 589487 Rydon, William, of Folkeston, shipman 1
5452444 2490607 2490607 defendant Claybrode William clerk 589487 589487 Claybrode, William, of Folkeston, clerk 0
5452446 2490607 2490607 defendant Cole William   589487 589487 Cole, William, of Folkeston, parish clerk 2
5456694 2491926 2491926 defendant Taillour William yeoman 589487 589487 Taillour, William, of Folkeston, yeoman 0
5456695 2491926 2491926 defendant Rigdon William shipman 589487 589487 Rigdon, William, of Folkeston, shipman 1
5464023 2494155 2494155 defendant Elbrok John draper 589487 589487 Elbrok, John, of Folkeston, draper 3
5464336 2494242 2494242 defendant Cole William   589487 589487 Cole, William, of Folkeston, parish clerk 2
5468543 2495531 2495531 defendant Taillour William yeoman 589487 589487 Taillour, William, of Folkeston, yeoman 0
5468544 2495531 2495531 defendant Rygdon William shipman 589487 589487 Rygdon, William, of Folkeston, shipman 1
5475598 2497699 2497699 defendant E_ John draper 589487 589487 E_, John, of Folkeston, draper 3
5485279 2500513 2500513 defendant Norman William husbandman 589487 589487 Norman, William, of Folkeston, husbandman 0
5487528 2501166 2501166 plaintiff Thorold Philip (legal representative) 589487 589487 Thorold, Philip, of Folkeston, executors of 0
5487533 2501166 2501166 defendant Jenkyn John fisher 589487 589487 Jenkyn, John, of Folkeston, fisher 0
5489797 2501831 2501831 defendant Herte James husbandman 589487 589487 Herte, James, of Folkeston, husbandman 0
5489798 2501831 2501831 defendant Baker Nicholas husbandman 589487 589487 Baker, Nicholas, of Folkeston, husbandman 1
5489799 2501831 2501831 defendant Nicoll Robert husbandman 589487 589487 Nicoll, Robert, of Folkeston, husbandman 2
5489800 2501831 2501831 defendant Stokke Simon husbandman 589487 589487 Stokke, Simon, of Folkeston, husbandman 3
5489801 2501831 2501831 defendant Stokke Thomas husbandman 589487 589487 Stokke, Thomas, of Folkeston, husbandman 4
5489803 2501831 2501831 defendant Bullard Thomas husbandman 589487 589487 Bullard, Thomas, of Folkeston, husbandman 6
5499965 2504942 2504942 defendant Goldworth John fisher 589487 589487 Goldworth, John, of Folkeston, fisher 0
5502269 2505634 2505634 defendant Goldworth John fisher 589487 589487 Goldworth, John, of Folkeston, fisher 0
5504709 2506391 2506391 defendant Hunte Thomas   589487 589487 Hunte, Thomas, of Folkeston, mason 0
5504710 2506391 2506391 defendant Wykam Robert   589487 589487 Wykam, Robert, of Folkeston, mason 1
5510129 2508003 2508003 defendant Cole John barber 589487 589487 Cole, John, of Folkeston, barber 3
5513745 2509153 2509153 defendant Tytenden Thomas cooper 589487 589487 Tytenden, Thomas, of Folkeston, cooper 0
5560517 2523034 2523034 defendant Grubbe Thomas husbandman 589487 589487 Grubbe, Thomas, of Folkeston, husbandman 0
5571100 2526108 2526108 defendant Roade John yeoman 589487 589487 Roade, John, of Folkeston, yeoman 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);