幻想名称数据库
我正在为我的网络应用程序构建一个演示数据集。我想要数千个“真实的”名字。它们不应该是名人或小说英雄的名字或会引起联想的名字。他们都应该有各种不同的、听起来不同但真实的男性和女性名字和姓氏。
出生日期和其他数据可以随机生成，但现在我遇到了名字问题。您对此有什么创意吗？
更新：戴夫是获胜者
使用他建议的工具的示例数据，identitygenerator.com（非常用户友好且功能强大的工具）：
mysql> select name, sex, dob from Customer order by rand() limit 30;
+-------------------+---------+------------+
| name | sex | dob |
+-------------------+---------+------------+
| Seth Copeland | male | 1958-03-02 |
| Nomlanga Short | female | 1993-09-15 |
| Cheryl Kerr | female | 1962-05-14 |
| Ralph Murphy | male | 1984-07-14 |
| Whilemina Sparks | female | 1975-08-07 |
| Bernard Atkins | male | 1953-02-23 |
| Kane Lowery | male | 1964-02-24 |
| Victor Johnson | unknown | 1993-05-31 |
| Lawrence Powers | male | 1965-12-24 |
| Arsenio Caldwell | male | 1965-06-29 |
| Beatrice Espinoza | female | 1976-01-09 |
| Gil Herring | unknown | 1992-10-09 |
| Nelle Rocha | female | 1956-02-29 |
| Chantale Benson | female | 1969-04-27 |
| Katell Harris | female | 1976-03-14 |
| Rajah Kline | unknown | 1974-01-19 |
| Quynn Pennington | unknown | 1950-06-22 |
| Abraham Clemons | male | 1982-07-14 |
| Coby Bird | male | 1989-03-14 |
| Caryn Buckner | unknown | 1979-12-01 |
| Kenyon Sheppard | male | 1963-02-19 |
| Dana Chandler | female | 1958-05-25 |
| Dara Hogan | female | 1983-10-22 |
| April Carroll | unknown | 1954-03-10 |
| Joan Stone | female | 1964-01-31 |
| Ella Combs | female | 1993-11-19 |
| Sacha Becker | unknown | 1964-01-06 |
| Gray Palmer | male | 1981-08-06 |
| Marny Rivers | female | 1953-06-02 |
| Dawn Hull | female | 1989-10-05 |
+-------------------+---------+------------+
30 rows in set (0.02 sec)
I am building a demo dataset for my webapp. I would like thousands of "real looking" names. They should not be names of famous people or fiction heroes or names that will evoke associations. They should all have various and different sounding but realistic male and female names and surnames.
Birth dates and other data can be randomly generated, but right now I am stuck with the names issue. Do you have any creative ideas for this?
UPDATE: Dave is the Winner
Sample data using the tool he suggested, identitygenerator.com (very user friendly and powerful tool):
mysql> select name, sex, dob from Customer order by rand() limit 30;
+-------------------+---------+------------+
| name | sex | dob |
+-------------------+---------+------------+
| Seth Copeland | male | 1958-03-02 |
| Nomlanga Short | female | 1993-09-15 |
| Cheryl Kerr | female | 1962-05-14 |
| Ralph Murphy | male | 1984-07-14 |
| Whilemina Sparks | female | 1975-08-07 |
| Bernard Atkins | male | 1953-02-23 |
| Kane Lowery | male | 1964-02-24 |
| Victor Johnson | unknown | 1993-05-31 |
| Lawrence Powers | male | 1965-12-24 |
| Arsenio Caldwell | male | 1965-06-29 |
| Beatrice Espinoza | female | 1976-01-09 |
| Gil Herring | unknown | 1992-10-09 |
| Nelle Rocha | female | 1956-02-29 |
| Chantale Benson | female | 1969-04-27 |
| Katell Harris | female | 1976-03-14 |
| Rajah Kline | unknown | 1974-01-19 |
| Quynn Pennington | unknown | 1950-06-22 |
| Abraham Clemons | male | 1982-07-14 |
| Coby Bird | male | 1989-03-14 |
| Caryn Buckner | unknown | 1979-12-01 |
| Kenyon Sheppard | male | 1963-02-19 |
| Dana Chandler | female | 1958-05-25 |
| Dara Hogan | female | 1983-10-22 |
| April Carroll | unknown | 1954-03-10 |
| Joan Stone | female | 1964-01-31 |
| Ella Combs | female | 1993-11-19 |
| Sacha Becker | unknown | 1964-01-06 |
| Gray Palmer | male | 1981-08-06 |
| Marny Rivers | female | 1953-06-02 |
| Dawn Hull | female | 1989-10-05 |
+-------------------+---------+------------+
30 rows in set (0.02 sec)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
有些网站会为您生成假名。我通常使用 fakenamegenerator.com 但我认为一次只能做一个人。 identitygenerator.com 有一个工具，可以生成大量随机名称 - 以及其他个人信息 - 可以以各种方式下载格式。
There are websites which will generate fake names for you. I usually use fakenamegenerator.com but I think that only does one person at a time. identitygenerator.com has a tool which which will generate a large number of random names - and other personal information - downloadable in various formats.
http://www.generateata.com/ 可以为各种列类型生成漂亮的数据。导出为多种格式，包括 SQL 插入脚本。
http://www.generatedata.com/ Can generate pretty good looking data for a variety of column types. Exports to a variety of formats, including SQL Insert Scripts.
这是我针对类似情况所做的操作。
我创建了一个包含 50-60 个名字的数组。我只是使用了我认识的人、与我一起工作的人等的名字。
我用姓氏制作了另一组音节（同样是我认识的人、与我一起工作的人）。
然后，为了创建一个名称，我会从第一个数组中随机选择一个名字，然后从第二个数组中随机选择并连接 2 个音节。就是这样。
Here's what I did for a similar situation.
I made an array with 50-60 firstnames. I just used the firstnames of people I know, people I work with, etc.
I made another array of syllabes from last names (again from people I know, people I work with).
Then to create a name I would randomly pick a firstname from the first array, then randomly pick and concat 2 syllabes from the second. That's it.
您可以使用 grep 做一些技巧，并从婴儿名字网站之一中提取名字。这需要你进行一些黑客攻击，但至少这些名字听起来是真实的。
You could do some tricks with grep and extract names from one of the baby names websites. It would require some hacking on your part but at least the names will sound real.
您可以使用 https://parser.name 为任何给定的国家/地区代码生成虚构名称。他们提供免费的 API，返回您可以使用的 JSON 对象。我用它来创建一个带有虚构用户名的开发数据库。
You can generate fictional names for any given country code with https://parser.name. They offer a free API that return JSON object that you can use. I've used it to create a development databases with fictional usernames.